This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Is it possible to have LightSpeed generate an index hint with a query? I want with(index(idx)) to be used as shown in the example below:
|
|
|
Yes, you can specify index hints as per http://www.mindscapehq.com/documentation/lightspeed/Performance-and-Tuning/Database-Hints
|
|