Index hint in Query object

Hi everyone,

Can any one tell me, Is it possible to use Index hint in Query object ? if Yes, please tell me.

Thanks & Regards

Siva Mohan Y


Why you need to use index hint in query? What is the exact scenario you wanna use that?

You can see morphx Document…There, they given this solution

Hi EnriqueKevin,

Thanks for your reply…

The Reason is,

To improve the performance we can fetch the data by using Query object and In this query I can put Order by or group by options for Sorting/Grouping. In the same way can I use Index hint for particular datasource.

Try this:

queryBuildDataSource.addSortIndex(indexNum(MyTable, MyIndex));

Hi Martin,

Thanks a lot , this is what i requried…

thanks for your reply…[:D]

Thanx lot.