Unique query from DBQLSQLTB

General
New Member

Unique query from DBQLSQLTB

Hi,

 

I am trying to find out the unique sqls from DBQLSQLTB.

If a particular sql is getting executed multiple times with different parameter values...that should be counted only once.

 

e.g. select col1,col2 from tab1 where col1='a';

       select col1,col2 from tab1 where col1='b';

I want to count above 2 sql statements ONLY once, intent is to ignore all the parameter values while  calculating uniqueness.

 

Regards

satya

 

 

1 REPLY
Apprentice

Re: Unique query from DBQLSQLTB

Hi Satya,

 

Not easy. Using DBQLSqlTbl then you'll have to do some parsing of the SQL text, essentially replacing every parameter value with a constant.

If the SQL is (or can be made to be) generated using parameter markers then that will make the process a lot easier, but the application has to do that, the DBMS cannot.

 

Cheers,

Dave

 

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