Success is about Imagination

Ignite Your Passion

kyle Hailey

May 7, 20142 min

Full table scan runs way slower today!

Every so often a DSS query that usually takes 10 minutes ends up taking over an hour. (or one that takes an hour never seems to finish)...

kyle Hailey

May 5, 20142 min

Right Deep, Left Deep and Bushy Joins in SQL

What is right deep verses left deep? Good question. In join trees (not VST) the object on the left is acted upon first then the object on...

kyle Hailey

Aug 28, 20132 min

CURSOR_SHARING : a picture is worth a 1000 words

Anyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause on highly concurrent...

kyle Hailey

Aug 28, 20136 min

Finding the slowest SQL execution of the same query

Does the query always execute in the same amount of time? If some executions are slower, what is the slowest execution time? When did...