Alias on Rownum might degrade performance in oracle.

We use First's row filtering(using Rownum) for lot of day to day functional implementation, Pagination being one of the best example. Rownum clause is best way to impose First - N Rows optimization and restrict subset of projected rows as desired. During one of performance case analysis , come across below format sql performing bad…