By mswatcher
via use-the-index-luke.com
Submitted: Feb 11 2012 / 13:17
Using window functions is yet another way to implement pagination in SQL. They offer a flexible and above all, standards-compliant option. But only SQL Server and the Oracle database allow to use them for a pipelined Top-N query. PostgreSQL does not use indexes for those queries and is therefore executing them very inefficiently. MySQL does not support window functions at all.
Add your comment
