Terateam UK Teradata Query Tuning
Target Audience: This course is aimed at Users who are experienced in writing SQL, and are handling large volumes of data spanning multiple tables.
Duration: 1 Day (5-6 hours)
Topics Covered:
- Efficient Data Storage and SQL produced by Teradata parallel architecture.
- Importance of Primary Index
- Efficient Join methods
- Use of Statistics to influence the Optimiser
- Use of 'Explain' to interpret the performance
- Measurement of usage, and magnitude of potential improvements
- Skewed Processing
- Correct use of Left Outer Joins
- Efficient use of Secondary Indexes and Join Indexes.
- Examples of good coding practice to overcome performance issues.
- Optimised Insert/Select.
Find Out More
If you would like to see some figures of improvements gained as a result of this course, please contact us using either the contact us page or the form to the left.
We will happily supply the evidence you need.
Please also see the Training FAQs page for answers to more of your questions.
