It's well-known that the application of database optimization techniques can improve query performance.

However these techniques are often overlooked when it comes to analytical queries (especially those in-database) as those queries are already significantly faster than analysts are used to. However the application of techniques, such as AJIs, MVC, MLPPI, soft RI and columnar partitioning, can all lead to further improvements in processing time. This talk explains those techniques and shows how they can be applied to analytical data sets to increase the productivity of the analysts. Examples from the field are presented detailing how they benefited the analytic process.

Note: This was a 2012 Teradata Partners Conference session.

Presenter: Paul Segal, PS Consultant – 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 Analytical Modeler, Data Warehouse Business Users

Course number:50481
Training URL:
Format:Recorded webcast
Credit hours:1.00