Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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!
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement