June 11, 2002 at 6:37 am
I have a fat 40 million row table.
I recently saved a lot of time by indexing that table (20 indexes) by opening many query analyzer threads and running indexes in parallel.
Are there other "parallel" routines I could be using?
Only UPDATE and DELETE lock a table, right?
If I partition the table could I update or insert in parallel based on a clustered index on a date field?
-Kevin
June 13, 2002 at 2:15 pm
creating a clustered index or changing the schema will also lock the table.
Steve Jones
June 13, 2002 at 2:27 pm
If I create the clustered index first will that help speed up creating the other indexes?
-Kevin
June 13, 2002 at 6:58 pm
No, the reason is the new index still has to scan the table for values then it will use the PK (if clustered) or a rowidentifier as a pointer to the datas location. TO speed access to the data up. The only special thing to keep in mind about a clustered index is if you alter it all other indexes will be automatically rebuilt.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply