Knowing what you want to achieve before thinking of how to achieve it – a query optimization example

(Tanel Poder) Today I received a question which was a good example of systematic problem solving approach. It was about getting a long-running query to run faster. It took a long time as the correlated subquery in the query was not unnested, was re-visited many times, causing the whole subquery subt

Read More - Register for Free Membership