Hi Masi, > Did you try my suggestion with moving the page select into to on-clause? > Maybe the smaller set on the page rids you of the file sort. Yes I did, it seems identical. Thanks John