DBQLSummaryTbl

Database
Enthusiast

DBQLSummaryTbl

Hi,

I have few questions regarding DBQLSummaryTbl

1. What is difference between DBQLSummaryTbl and DBQLObjTbl ?

2. What is the mening of objecttype = col and Idx

3. What is the meaning of Object_Cnt 

4. How can this be used to see which columns are used how many times and to suggest change in PI (any sql)

Any link to a doc having more into on this.

Thanks !

2 REPLIES
Enthusiast

Re: DBQLSummaryTbl

Hi all,

Could someone please reply to this..thanks !!

Enthusiast

Re: DBQLSummaryTbl

You can try different documents on the below link (especially the B035-1093-067A one)

http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=DBAD...