Hi,

am using hibernate paginateion, when i am using startIndex and get max Results, its constructing a subquery like

select * from ( select row_.*, rownum rownum_ from ( select

so its affecting performance of the query,

could you plz suggest me the way of improving for performance, am using hibernate criteria .

Thanks
Kathir

Have you tuned your inner most select statement (the query inside the rownum wrapping)? We use hibernate pagination with Oracle and as long as the inner select is optimally performance tuned then performance with rownum logic is fine. Good luck.