Query Analysis Tool

Tools & Utilities

Query Analysis Tool

Which query analysis tool can be used to identify the queries that used a new Index structure during last one month?

1) PMON
2) DBQL
3) Visual Explain
4) Teradata WorkLoad Analyzer

If the answer is DBQL the using which DBQL Table is used to check this?
2 REPLIES
Teradata Employee

Re: Query Analysis Tool

DQBLOGTBL

Highlighted
Teradata Employee

Re: Query Analysis Tool

OBJECTS logging (DBQLObjTbl) would be used for this.

In theory it might also be possible to analyze detail information from EXPLAIN or XMLPLAN logging, but that would be a much more complex task.