All Forums Database
kepler 1 post Joined 08/12
30 Aug 2012
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 ?

 

HelmutR 6 posts Joined 01/13
20 Feb 2013

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
 

sa186016 5 posts Joined 04/11
18 Apr 2013

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

SA

pawan0608 101 posts Joined 12/07
19 Apr 2013

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
 
 

teradatauser2 236 posts Joined 04/12
21 Apr 2013

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

pawan0608 101 posts Joined 12/07
22 Apr 2013

I have responed to your original post

You must sign in to leave a comment.