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.
Solved! Go to Solution.
No there isn't. As you've spotted QueryID is unique to each execution of a query.