QUESTION POSED ON: 11 March 2008 We removed the local temporary table inside the stored procedure, and made it into a permanent table. The execution time for this permanent procedure is now a longer process when compared with the local temporary table procedure. Why does this happen?
>
EXPERT RESPONSE
If other users are using the same table, you may have some locking issues that need to be looked at. I would move the stored procedure back to using temporary tables instead of permanent tables, as temporary tables will be cleaned up automatically when the sessions are closed.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
