All Forums Database
Kishore_1 208 posts Joined 03/10
12 Mar 2016
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!

You must sign in to leave a comment.