Success is about Imagination

Ignite Your Passion

kyle Hailey

May 7, 20142 min read

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)...

34 views0 comments

kyle Hailey

May 5, 20142 min read

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...

537 views0 comments

kyle Hailey

Aug 28, 20132 min read

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...

27 views0 comments

kyle Hailey

Aug 28, 20136 min read

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...

74 views0 comments