Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Tamar,
SNIP
It seems pretty clear that Rushmore will use any available index, whether it will speed things up or not. Of course "any available" has to be one (or more) that is relevant to the query at hand.
I've seen temp indexes created too, but don't see the relevance to the issue you've replied to.
I'd certainly like to see more "intelligence" applied in Rushmore. One of the first would be assessing the variation of an index' initial nodes and rejecting its use in many circumstances.
>
>No, Rushmore looks at available indexes to see whether any of them will speed up the operation. If you look at SYS(3054) output, sometimes you'll see that VFP uses a temp index even when there's one available.
>
>Tamar
Précédent
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