What do the # in 0TCTSTEPCNT mean?

[vitran23]

I'm trying to build a query to get usage data on queries we've developed.  I noticed there are multiple query steps per sessions occasionally.  How do the 0TCTSTEPCNT id's coorelate to the query steps?  What do the ids mean?

Currently in my query I'm seeing numbers like 3, 4, 9, 10, 13, 14, 17, 20, 23, 31....

[vitran23]

So is there a definition to each of these counter step numbers?

Like what is a 1 or a 3?  I noticed that 1's done add to the counter.

[RamanKorrapati]

Hi,

its standard characteristic info object.

0TCTSTEPCNT - its step counter during query execution.

as my guess you may be using technical contents data.

Thanks

[vitran23]

Currently I'm using 0TCTQUCOUNT but the numbers are looking inflated.

I read I should filter on 0TCTBIOTYPE = 'ELEM' and 0TCTSTEPCNT = 1 but I can't do the last one since I don't have any 1's.

[RamanKorrapati]

there is no 1 and 2. So try to filter 0TCTSTEPCNT = 3 and check the results.

[vitran23]

Ramanjaneyulu, I did filter on 3 but it doesn't seem to be right because I ran 2 separate reports to test out my theories.  One of the report has a 0TCTSTEPCNT of 3 while the other had a 4.  All that was done for both reports was I inputted the variables needed and ran the query.