how can we enable DBQL Explain logging for specific user?

Database
Highlighted
Teradata Employee

how can we enable DBQL Explain logging for specific user?

If someone performed this activity please let me know and also share history + solution

2 REPLIES 2
Ambassador

Re: how can we enable DBQL Explain logging for specific user?

Try:

BEGIN QUERY LOGGING WITH EXPLAIN ON username;

HTH

Dave

 

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

Re: how can we enable DBQL Explain logging for specific user?

Point to consider, enabling ONLY a specific logging for a user ( like EXPLAIN in this case) will turn off any other logging options (e.g. OBJECTS, SQL) the user would inherit from " ALL " users level . If those other logging options need to be retained for this user along with EXPLAIN, then specify all the options defined at "ALL" users level along with EXPLAIN in one BEGIN LOGGING statement for that user.