August 14, 2008 at 8:19 am
Can I build a index on a temporary table in a stored procedure?
August 14, 2008 at 10:04 am
Yes you can. It is the same syntax as for permanent tables. Remember a temporary table is really a permanent table in tempdb that is hooked to a session and dropped when the session ends so you have all the functionality that a "real" table has. Sometimes adding an index to a temp table can drastically improve performance.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 20, 2008 at 2:55 pm
Thankyou.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply