Optimal offset pushdown for multipart sorting

摘要: In some aspects, a method, computer program product, and system are provided for query optimization. implementations, there may be method including detecting select as candidate optimization, the an order by, offset value, limit value; determining, in response to detecting, modified value difference between size of smaller dataset; performing form result set, executed based on at least value. Related systems, methods, articles manufacture also described.