Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Rushmore optimization - index composed of 2 fields
Versions des environnements
Hello,
I have a table with some fields including LNAME and FNAME (Lastname/Firstname).
One index on LNAME+FNAME
I want to make several requests :
- only lnames beginning with... (SELECT * FROM t1 WHERE LNAME="A")
- both lnames and fnames begining with..(SELECT * FROM t1 WHERE LNAME="A" AND FNAME="B")
Is it possible to have Rushmore optimized requests in both cases only with the index LNAME+FNAME ?
In general, in case of a request based on 2 fields (like the 2nd one), is it working with a unique index based on these 2 fields ?
In VFP9sp1, I'm wondering why I have to set ENGINEBEHAVIOR to 80 to have a working Rushmore optimization on a very simple request.
(CPCURRENT() is equal to CPDBF())
Thanks for your help.
Regards,
Steph
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