Let's say we are runnig a complex query and our objective is to tune it for better performance. We know we can find which join is used by optimizer by examining the execution plan, but we all know execution plan provides a ton of other useful information too. let's say we just want a quick …

Continue reading Finding join types in a query for performance tuning