SQL performance is vital for driving value from a data warehouse. With today's growing query complexity, optimizing SQL can be a daunting task ...

This session provides a fundamental method for SQL tuning that has been used and refined through thousands of tuning exercises. The structure and process in this method generates a context that minimizes the complexities and gets to the root of the performance issues, which enables faster remediation. Further, the method provides a consistent, repeatable process that can be leveraged across the organization from the end user to database administrator. In addition to the structured method, the presenters share insight on typically seen performance problems and provide sample remedies. This provides the attendee with insight to commence their tuning efforts.

Key Points:

  • SQL tuning can be a daunting task. This method leads an analyst to diagnose & see the root cause of a performance issue in the process of developing a solution.
  • The attendee receives a proven tuning method that has been used to systematically diagnose & fix 1000s of SQL tuning issues.
  • SQL tuning diagnostics with typical problem types & sample remedies are provided.

Updated: Aug. 3, 2016

Presenters:
Arnie Van Wyck – Teradata Corporation
David H. Gardner – Teradata Corporation

This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.

Audience: Data Warehouse Administrator; Data Warehouse Application Specialist; Data Warehouse Architect/ Designer; Data Warehouse Modeler; Data Warehouse Technical Specialist

Course number:45703
Training URL:http://www.teradata.com/t/ten/
Format:Recorded webcast
Price:$195.00
Credit hours:1.50