While working on multiple queries for tuning... How i can identify the queries while getting the DBQL details
For ex: I have 20 queries from developer, need to provide recommendations for performance. I need to run thru multiple iterations, making changes, again run, & check for CPU, Spool, rows etc.
Is there any easy ways i can add like Query1, Query2 in querytext or any other way to identify the query while working on them simultaneously.
Check the queryband option - you can set for each query a different queryband parameter.
This will be visiable in DBQL.
Or add a comment to the query text like
-- my query 1
in this case you can see it from the querytext in dbql.
Thanks ulrich !
But these comments are not visible in querytext/SqlTextInfo in DBQL...Thats the problem...
Do you think this could be due to some logging option on my side?
Could you pls let me know the quick way to set queryband for the query?
Raja: I use both VP & DBQL. What i was looking like ... I have many queries to tune.
Those take long time to run. I'll run those at sametime and i need to see their resouces consumption. And i need to do many iterartions in order to make chages & again see the improvement.
hope i am not confusing you :-)
SET QUERY_BAND = 'sqltype=perftest;sqlnr=1;runid=1;' UPDATE for SESSION;
and you need to run this before each SQL and change the numbers;
/*my query 1 */
at least I see sometimes SQL in DQBL with comments in it...
As above statements indicate it also depends on how you connect to the DB - but so far you didn't say which tool you use, how you connect (.net, ODBC, JDBC) etc.
Did you try the queryband option?