General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Rushmore optimization - index composed of 2 fields
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only