Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Rushmore in group by and aggregates?
I know how VFP uses rushmore in a where clause (reasonably well), but I don't know what it does in more complex sql statements.
What indexes would be relevant for the following query?
SELECT order_num, item_code, sum(quantity) as tot_qty ;
from kit_orditems ;
group by order_num, item_code ;
having count(*) > 1 ;
into CURSOR dups
There are already indexes on order_num and item_code. Do the group by fields (or expressions) need to have indexes?
How about the having clause?
TIA
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