Tuesday, 10 November 2015

index at queryrun

it is possible to use index hint in query object. 

try :

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


people use index hint in query is because to improve the performance we 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 i can use index hint for particular datasource.



No comments:

Post a Comment