By DanHotka (User) on
3/7/2012 11:17 AM
The Plan Table QBlock Name column is used in conjunction with a hint to expose exactly where the sub queries of a SQL statement appear in the Plan Table.
|
By DanHotka (User) on
2/23/2012 1:50 PM
New PLAN_TABLE support starting in Oracle10g.
|
By DanHotka (User) on
9/6/2011 7:30 AM
A quick review of the important features of the virtual Oracle SQL Tuning for Developers using TOAD
|
By DanHotka (User) on
5/10/2011 10:53 PM
Use coding style to avoid hints...TOAD is full of tuning tools...
|
By DanHotka (User) on
5/9/2011 11:25 AM
TOAD has many features I illustrate during my SQL Tuning for Developers course...
|
By DanHotka (User) on
5/9/2011 11:16 AM
On-site class this week in Cork and Dublin Ireland. This is a 2-day on-site class exactly like the 4-half day web class being offered by Quest Software the week of June 20.
|
By DanHotka (User) on
5/9/2011 11:02 AM
The last day of the Adv PL/SQL class covers large objects and TOAD Debugging and Profiling Tools
|
By DanHotka (User) on
5/5/2011 6:35 AM
Dan covered Ref Cursors and PL/SQL Collections in yesterday's Advanced PL/SQL class.
|
By DanHotka (User) on
5/4/2011 4:52 AM
Dan covered compiler options including conditional compilation in yesterday's Advanced PL/SQL class. He also covered advanced topics using database triggers including updateable views and audit trails.
|
By DanHotka (User) on
5/3/2011 5:53 AM
Hi! Watch for my blogs on SQL Tuning and PL/SQL Tips and Techniques.
Right now I am teaching the Advanced PL/SQL class for a client over the web. I'll keep you posted with how it is going.
I am focused on training and Quest Software and I have worked out an arrangement where I teach my popular Oracle SQL Tuning for Developers using TOAD and Advanced PL/SQL Tips and Techniques using TOAD (and of course...
|