Some queries, mostly reporting ones, have to be optimised when they use tables with millions of rows because their execution times make them unusable. We will see how to improve their performance including certain features that are specific for Oracle databases.

Continue reading →