SQLTXECUTE execution time
Hello All,
As per "sqlt_instructions.html":
XECUTE Method:
"This method provides more detail than XTRACT. As the name XECUTE implies, it executes the SQL being analyzed, then it produces a set of diagnostics files. Its major drawback is that if the SQL being analyzed takes long to execute, this method will also take long.
As a rule of thumb, use this method only if the SQL takes less than 1hr to execute, else use XTRACT".
I get lot of queries that run more than an hour...if i were still to use XECUTE Method(saves time instead of manual trace and other reports related to query) is there a workaround by any chance to LIMIT amount of time for the SQL to execute and then generate report.