General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Randy,
Now that you confirm that improvements were made to (re)index, can we get more details so that we can exploit to the fullest?
Thanks in advance,
jim N
>Evan,
>
>Good catch. Along with some of the multi-threading optimizations and improvements, we (Calvin) were also able to make some additional optimizations in the indexing routines.
>
>Randy [MSFT]
>
>>I have experienced a drastic decrease in the time it takes to index/pack tables with SP3. I have a 1 million record table that took almost 30 minutes to index on 7 expressions. This now takes under 10 minutes. Has anyone else observed this. Wow!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only