thanks chris.

I will try to run this query and see any performance change. We have 8.1.6.0, but planning to upgrade it to
8.1.6.2. Please let me know what will change if we upgrade.
Also, I am running this query from procedure, so I can take
advantage of NDS. But as in previous post, when I try to bind rownum in procedure, I don't get any results. So, I had to put values for rownum <= 15 while building SQL stmt.

thanks,

np70