Are there index hints in Pervasive

[john230873]

Are there index hints in Pervasive 2000i?

 

[mirtheil]

That's kind of vague. What kind of hints are you looking for? What are you trying to do? Is it not working the way you expect? Give us a little more information.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[john230873]

We use dataflex as the main programming tool. In this you can tell the program which index to use and the program works fine. In pervasive SQL I would like to inform the query which index to use as I beleive it is chossing the wrong one and taking more time that is needed.

 

[mirtheil]

There's no way from an SQL statement to tell the engine which index to use. You can use the Query Plan Viewer to check to make sure that it's using the right index.
From a Btrieve perspective, you can tell it which index to use.

What's the query you are issuing and what index do you think it should be using? Also, how are you determining that it's not using the proper index?



info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[john230873]

Thanks mirtheil you have answered the question