October 29, 2010 at 6:03 am
Hi,
can we create temporary indexes on table ?
Subha
DBA
October 29, 2010 at 6:12 am
You need to define temporary...
you can always create an index, use it and then drop it.
Assuming an ETL job. I'd just enable/disable it so that I don't have to worry about the index definition in the code.
October 29, 2010 at 6:43 am
Another option to creating an index is to create statistics. However, neither index nor statistics can be created and then automatically dropped. Any create requires a subsequent drop action on these objects.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2010 at 8:51 am
Thank u very much for your Valuable info..
Subha
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply