Success is about Imagination

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

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

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

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