In the following sample code:
return query.Skip(X).Take(Y);
the generated SQL will have X and Y in the query as constants rather than bind variables.
For example: "ROWNUM <= (50)" instead of "ROWNUM <= (:p__linq__1)"
This makes optimizing oracle for the page that uses the query much more difficult.
Is there a way to get the generated SQL to use bind variables for the paging?