Is there any Column/Attribute in Teradata DBC/System tables similar to SQL ID in Oracle ?

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

Is there any Column/Attribute in Teradata DBC/System tables similar to SQL ID in Oracle ?

 

Is there any Column/Attribute in Teradata DBC/System tables similar to SQL ID in Oracle ?

SQLID - Is an ID which will uniquely identify that SQL. Example the SQL ID for a query will always be same irrespective of the application/user fires this query.

We assumed Query ID - But it is not matching with SQL ID. We are trying to understand the behaviour of the same SQL how it performed over period and currently. So is there any Column/Attribute in Teradata DBC/System tables which can identify the Query uniquely and it has to be same irrespective of Users/Applications fire.

 

Thanks,
Arun


Accepted Solutions
Junior Contributor

Re: Is there any Column/Attribute in Teradata DBC/System tables similar to SQL ID in Oracle ?

QueryID identifies unique queries, SQLID identifies unique SQL statements.

You might try to hash the SQL Text from QryLogSQL to assign a unique number...

1 ACCEPTED SOLUTION
4 REPLIES
Junior Contributor

Re: Is there any Column/Attribute in Teradata DBC/System tables similar to SQL ID in Oracle ?

QueryID identifies unique queries, SQLID identifies unique SQL statements.

You might try to hash the SQL Text from QryLogSQL to assign a unique number...

Senior Apprentice

Re: Is there any Column/Attribute in Teradata DBC/System tables similar to SQL ID in Oracle ?

No there isn't. As you've spotted QueryID is unique to each execution of a query.

Dave

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Enthusiast

Re: Is there any Column/Attribute in Teradata DBC/System tables similar to SQL ID in Oracle ?

Thanks for you response !

Enthusiast

Re: Is there any Column/Attribute in Teradata DBC/System tables similar to SQL ID in Oracle ?

Dnoeth, Thank you and Appreciate your help !!