Jonathan Lewis Oracle Seminars - (Day 2 - Writing Optimal SQL)

One day: $350 for DOUG members, $400 for non-members
Both days: $650 for DOUG members, $750 for non-members

Sign up for both days and receive a registration discount!

	Status:	Completed
	Speaker:	Jonathan Lewis
	Location:	SMU-in-Legacy Campus 5236 Tennyson Parkway Building 4 - Room 122 Plano, TX 75024-3544
	Sponsor:	Dallas Oracle Users Group
	Date:	Oct 29, 2009
	Price:	$350.00 for DOUG members ($400.00 for non-members)
	Agenda   Speaker Info   Sponsor Web   Waiting List Driving Directions Nearby Hotels   Registration Closed Who should attend? Experienced DBAs and Developers. This is a fast-paced class and attendees should have a good understanding of Oracle. Additional Seminar Information This tutorial has two targets. First: how do you improve the performance of a production system by attacking inefficient SQL; secondly: how do you design a system so that you can get data into and out of it efficiently. For most people, the design has already happened, nevertheless you need to be aware that the two targets overlap significantly - as you struggle to address a particularly inefficient piece of SQL, you need to be aware that there are structural features of the database that may help you find a cost effective solution despite the problems imposed by the SQL itself. The course will focus on the SQL - falling back to structural issues only as an aid to improving the mechanical efficiency of the SQL solution - but we will spend some time explaining the pros and cons of various structural options as they become relevant to the SQL. The course will cover methods of reviewing data distribution patterns, use of indexes, use of views (stored and inline), analytic functions, subquery factoring, as well as statistics, hints, and a brief review of execution plans.