Query Entity: Effect of Adding /*+FIRST_ROWS(10)*/ Hint in View

Question

Hi All, 
 We have added /*+FIRST_ROWS(10)*/ Hint in one of our oracle views for the optimization. We are fetching the data from Appian into batches of 200 from this view. 
 I am curious to know whether this hint will have any effect on the data being fetched from Appian (In terms of actual data). In terms of performance yes definitely it improved the performance but I am observing below issue: 
 I am using batch size as 200 
 From Start Index 601 data i not getting changed and I am getting the same data every time. Is this "Hint" the culprit or there is some other issue. (Maybe this issue was already there) 
 (Our Query Entity is simple without any filter just with Paging Info where I am passing Start Index and Batch Size as ri!

aloks0189 · Answer

Hi @prakash as per my understanding, there can be multiple reasons behind this issue. 
 
1. Improper pagination 
2. Unavailability of sortInfo() in pagingInfo 
3. Appian is much flexible with MySQL db compared to any other including Oracle, hence I suspect, whether Appian really supports all the features of Oracle db or not, so this might be an another root cause 
 
Hope this will be helpful