Index hint in Query object

Finance and Operations/AX Technical Forum
1

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

2

Hi,

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

3

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

4

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.

5

Try this:

queryBuildDataSource.addSortIndex(indexNum(MyTable, MyIndex));
queryBuildDataSource.indexIsHint(true);
6

Hi Martin,

Thanks a lot , this is what i requried…

thanks for your reply…[:D]

7

Thanx lot.