Have you ever struggled over whether, or how, to use a new database feature?  In this presentation, we’ll demonstrate how database query log (DBQL) data can help when it comes to determining candidates for MLPPI (Multi-Level Partitioned Primary Index) as well as the new Columnar Partitioning feature of Teradata 14.

This presentation will discuss using DBQL object data for gathering such key information as frequency of use, large scan, and total query counts, as well as CPU and I/O usage.  In addition, the presentation will review techniques for testing and validating conclusions, instilling confidence in your decisions.  Finally, learn how the wealth of information available from DBQL can make it easier for you to benefit from the performance advantages that come with features like MLPPI and Columnar.

Note: This was a 2012 Teradata Partners Conference session.

Teradata Release information: TD 13 & 14

Barbara Christjohn, Performance COE – Teradata Corporation
David Hensel, Performance COE – 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 Architect/Designer, Data Warehouse Technical Specialist

Course number:50495
Training URL:http://www.teradata.com/t/ten/
Format:Recorded webcast
Credit hours:1.00