Webinar June 10 - Jonathan Lewis and I on Visual SQL Tuning
- From: kyle Hailey <kylelf@xxxxxxxxx>
- To: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 2 Jun 2010 12:59:31 -0700
Jonathan Lewis is my favorite presenter on Oracle performance and tuning and so I'm both excited and nervous that Embarcadero is hosting a free live webinar co-presented Jonathan Lewis and myself. I'm excited about the webinar because Jonathan and I will be talking about how query diagram visualizations can aid in the tuning of SQL queries and I'm a huge fan of using data visualization to approach performance and tuning challenges. In the webinar Jonathan will point out the information required to find the best execution in the query and show the benefits of visually diagramming the query. I'll follow up with more information on systematically approaching SQL query tuning from a visual point of view. For a taste of Jonathan's content see: http://www.simple-talk.com/sql/performance/designing-efficient-sql-a-visual-approach For some ideas on mine see : http://sites.google.com/site/embtdbo/sql-tuning-1#TOC-Visual-SQL-Tuning-in-Action: (please take the punchy marketing write-up with a grain of salt ! ) Register for the live webinar on June 10th here: http://www.embarcadero.com/master-sql-tuners-oracle-lewis-hailey Tune in for the Ultimate SQL Tune-off According to Jonathan Lewis, there is a basic strategy to writing efficient SQL, but it requires knowledge of the data, the metadata, and the intent of the query. Jonathan will start with the basic principles of efficient data access and then show different ways of analyzing the data. He'll then describe a graphical approach to finding the most efficient access path for a query and then apply the method to a problem he recently saw with one of his clients. But wait... is there more than one way to skin a cat? Kyle Hailey thinks so, and he's not afraid to let Jonathan know it! Kyle's fancy footwork will include his own approach to Visual SQL Tuning (VST) with some ring side support from DB Optimizer XE. Hitting below the belt? You be the judge.
Other related posts:
- » Webinar June 10 - Jonathan Lewis and I on Visual SQL Tuning - kyle Hailey