Tag Archives: SQL tuning

How to make partition elimination/pruning to work

The blog was moved to: http://www.avmconsulting.net/single-post/2016/11/19/How-to-make-partition-eliminationpruning-to-work Check us out on http://avmconsulting.net

Posted in Oracle | Tagged , , , , , | Leave a comment

Top-N query

Term of “TOP-N” intuitively makes thinking what they query should run faster than just ORDERED query, as only N elements needed from it. But, as well known, not always.. This blog describes method how using proper index would optimize TOP-N  … Continue reading

Posted in SQL | Tagged , , , | Leave a comment