About QryLogObjects and the FreqofUse column.

Teradata Employee

About QryLogObjects and the FreqofUse column.

I have questions about the true meaning of the objects to be logged in this view. I understand this view will be populated when I enable logging on "Object Names".

It seems to me that it does not faithfully log ALL columns and tables showed in the SQL; instead, its log is based on the Explain steps. In other words, only the column and table names showed in the Explain text will be showed up in this table. Is my observation correct?

Also, based on my observation, the FreqOfUse column in this view is the number of times the object showed up in the Explain steps. So the value some columns in one SQL are more than one. And some columns do not get logged even though they appeared in the SQL. Is this correct?