Archives of the TeradataForum

Message Posted: Tue, 02 Aug 2005 @ 18:04:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hey John

You have asked a specific question on a "How To" and made mention to what you are actually trying to achieve.

If I may...

Are you simply trying to determine what columns in the tables are being used based on the user queries?

If that is the case, turn on Query Logging using DBQL (objects) and it will capture what columns in what tables are being accessed. This will not tell you what views are being accessed but it will tell you what tables and columns are being accessed.

The DBQL Objects capability will translate the accesses to views to the underlying tables. This may answer the question that you are ultimately trying to answer without sifting through all of the view logic to get there.

If I am way off base please forgive me.

Chris Coffing
Air Force Knowledge Services (AFKS)
Lead Operations & Support
Lead Teradata DBA
Teradata NCR Contractor
Teradata Certified Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>