Success is about Imagination

This is more of a bookmark for a future blog post on using the Cardinality hint. This post by Greg Rahn give some example and I posted in...

A good part of my presentation Friday at NoCOUG was on explain plan command being an estimate of the actual execution plan. Now on the...

here is a feature that I’m excited about: Real Time SQL Monitoring http://askdba.org/weblog/2009/09/11gr2-monitoring-real-time-sql-plan-e...

Ever wonder why some of those DBA_ views take so long to execute? here is the view expansion of a query from SYS.DBA_ALL_TABLES joined...

dbms_xplan.display_cursor will output the hints for a plan. These hints can then be taken and used in an outline for plan stability:...

Nice table on http://www.psoug.org/reference/dbms_xplan.html and some more discussion on http://jonathanlewis.wordpress.com/2008/03/06/db...

Diff’ing explain plans is difficult and tedious.>Here is a new package function from Oracle for diff’ing explain plans...

Explain Plans can be had via Explain Plan (version ? ancient) Trace Files (starting 7.3) Autotrace (starting 8.1.7) V$SQL_PLAN (starting...

Check out Alberto Dell’Era’s SQL query analyzer – lots of good info like this compact table of indexes availble on the query:...

Growing up on Ansi 89 and working at Oracle for 10 years, some of the the cleaner SQL join notation seems new to me. Here is a great...