Monthly Archives: November 2017

Does the Explain Plan command really show the execution plan that will be used?

When it comes to SQL tuning we often need to look at the execution plan for a SQL statement to determine where the majority of the time is spent. But how we generate that execution plan can have a big … Continue reading

Posted in Beginners, Optimizer | Tagged , , , | Leave a comment

Oracle Autonomous Database – What you need to know

At OpenWorld, Larry Ellison announced ¬†an Autonomous Database¬†cloud (service), which is self-driving, self-securing, and self-repairing. Although there was a lot of excitement surrounding the announcement, there were also a lot of questions. How does it work exactly? When and where … Continue reading

Posted in Autonomous Database, OOW | Tagged , , | 3 Comments