The field typeofuse of the table dbc.dbqlobjtbl according to the manual (TD14) has the following values:
1 = Found in the resolver
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
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
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