Entrepreneurship Calendar

Back to Listing

cuDBUG

Event Type
Other
Sponsor
EnterpriseWorks and Research Park
Location
EnterpriseWorks Conference Room 130, 60 Hazelwood Drive Champaign, IL 61820
Date
Jan 29, 2014   3:30 pm  
Speaker
Chris Stephens
Contact
Charles Linville
E-Mail
linville@ploughman-analytics.com
Views
793
Originating Calendar
Research Park Events

Join us for a session led by Chris Stephens:

Despite steady improvements in the capabilities of database optimizers, SQL performance remains an issue for most IT shops.  Identifying poorly performing SQL and determining its current execution plan is a fairly straightforward process.  Determining an optimal execution plan for a given SQL statement and convincing the database to follow that plan remains an issue.  This presentation introduces the concept of Query Diagramming, a vendor-neutral technique that provides a framework for determining optimal execution plans. Query Diagramming is discussed in detail in the book SQL Tuning, by Dan Tow.

Chris Stephens has been a database administrator for 15 years and is currently working for Archer Daniels Midland.

link for robots only