Anlysing DBQLXMLTbl Data

Database
Enthusiast

Anlysing DBQLXMLTbl Data

Recently we have enabled XML logging on our Teradata system.Found out some missing stats in the xmlplan:

          <StatsMissing Importance="High">

            <RelationRef Ref="REL2"/>

            <FieldRef Ref="REL2_FLD1026"/>

          </StatsMissing>

          <StatsMissing Importance="High">

            <RelationRef Ref="REL2"/>

            <FieldRef Ref="REL2_FLD1032"/>

          </StatsMissing>

Question: What are xml functions available in TD to extract the databasename,tablename,columnname  missing stats?

Any query showing usage will be helpful.

Thanks in Advance!

Tags (2)