SQL optimization and tuning is fun for a lot of folks. For others it’s a affirmation that the database is ‘magic.’ I fall somewhere in the middle. No matter where you find yourself on that spectrum however, it’s pretty safe to assume that at some point you will look at an execution plan for insight [...]
explain plan
SQL Developer Quick Tip – Pin Query Result Sets and Plans
It’s very rare that a query is developed in a single take. You start with a framework, and then trim down to the essential elements. Then you start working about sort orders, performance, and formatting. As you develop your SQL, you may want to keep several iterations of the data and their plans available. SQL [...]
Twitter
RSS
GooglePlus
Facebook