DBQLOBJTBL - unknown values

Database
Teradata Employee

DBQLOBJTBL - unknown values

Hi ,

The field typeofuse of the table dbc.dbqlobjtbl according to the manual (TD14) has the following values:

1 = Found in the resolver

• 2 = Accessed during query processing

• 4 = Found in a conditional context

• 8 = Found in inner join condition

• 16 = Found in outer join condition

• 32 = Found in a sum node

• 64 = Found in a full outer join condition

Note: More than one of these values can be used.

but in my database (Teradata 14.0 ) I have the values :

TypeofUse

1

2

3

6

14

22

30

34

38

46

Somebody know the meaning of this values ?


5 REPLIES
Enthusiast

Re: DBQLOBJTBL - unknown values

Hi Kepler,

I think your question was already answered somewhere else ...

But in my opinion you have to see this like a bitmask

1   = Found in the resolver =                      0000001

2   = Accessed during query processing =  0000010

4   = Found in a conditional context =        0000100

8   = Found in inner join condition =           0001000

16 = Found in outer join condition =          0010000

32 = Found in a sum node =                      0100000

64 = Found in a full outer join condition = 1000000

If you find e.g.

3: means 0000011 --> Found in the resolver/Accessed during query processing

22: means 0010110 --> Accessed during query processing/Found in a conditional context/Found in outer join condition

Best regards

Helmut

Enthusiast

Re: DBQLOBJTBL - unknown values

even i m confused about this ,please let me know if anybody knows the ans of this question.....

Enthusiast

Re: DBQLOBJTBL - unknown values

in simple words, the values which are not in the list mentioned in TD14 manual, but you see in your table are actully the sum of any of those values from the list ike 3 = 2 + 1, 6 = 2+ 4 etc.

So, 3 represents  Found in the resolver + Accessed during query processing

Enthusiast

Re: DBQLOBJTBL - unknown values

I have posted another question for choosing secondary index on a table. Someone pointed to use this column for taking this decesion.

Can anyone share sql and explain how this column value can be use for this.

My original question link => http://forums.teradata.com/forum/database/creating-a-new-secondary-index-on-table#comment-31084

Enthusiast

Re: DBQLOBJTBL - unknown values

I have responed to your original post