I have a report. It takes 30 seconds to run but I want the report little more quick.

when I run a sample query in query tools:

select * from default_vw where account_number = '12345';

It takes 3.50 seconds

In App Stdio : the response time is 5 seconds for simple table request.

and when I use parallel hints

Select /*+ parallel(2) */ * from default_vw where account_number= '12345'; takes 1.25 seconds.



My question , How can I cut down my response time.


Can any one please suggest me a good approach in solving this.

Thank you all.

This message has been edited. Last edited by: FP Mod Chuck,

Depending on the RDBMS indexing the account_number field might speed things up.

You can insert the hint.

SQL SQLORA SET HINT /*+ parallel(2) */  

TABLE FILE ...

Doc here

Adding this to your EDASPROF.PRF can also help:

ENGINE SQLMSS SET FETCHSIZE 5000

Change SQLMSS to SQLORA if you are using Oracle.

"Performance enhancement?"

LOLZ I was like dare I open this?