SkyhiKeeper
Programmer
I need to be able to susspend the building of the indexes during an insert into a table, how can this be done?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you suspend the building of an Index during an insert into
- Thread starter SkyhiKeeper
- Start date
- Status
MartinCroft
Programmer
hi
One option is to script the index ( you probably have this alreay) drop the index do the insert and then create the index. This will give better performance and recreating the index after the index will be better.
One option is to script the index ( you probably have this alreay) drop the index do the insert and then create the index. This will give better performance and recreating the index after the index will be better.
- Thread starter
- #3
SkyhiKeeper
Programmer
Thought as much just wanted verification, Thanks
- Status
Similar threads
- Locked
- Question
- Locked
- Question