Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Rushmore with Index Set
First off, I'm new, perhaps the answer is already out there, sorry if it is... please point me in the right direction and kick gently. :)
Anyway, I wrote a program a while back that opened a table and did a completely Rushmore optimized search over a network. The table had about 10 million records in it. The code was using SET ORDER TO early on (for display) and then later called a fully Rushmore optimized SQL statement. This SQL statement took FOREVER (like an hour). I thought that was strange, and after some investigation found that it was searching the records sequentially and hauling all the data over the network.
I found that if I did a SET ORDER TO by itself so no index order was set it worked in less than half a second (obviously "Rushmore optimized") but if I used SET ORDER TO [Tag] to set an index order first it did a sequential search.
I've never seen anything anywhere that says Rushmore only works without an index set. Without doing a search over the network using millions of records I never would have noticed it (it worked fine on my development PC with a local table).
Anyone know of where this might be documented, and why it's that way?
Thanks.
Suivant
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