Showing posts with label index hint. Show all posts
Showing posts with label index hint. Show all posts

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.