Using big queries vs. Stored procs in Crystal Report using DB2

[varshan09]

Hi,

If we write big queries inside Crystal report to fetch data, instead of stored procs using DB2 v7.0. Will there be any difference in terms of performance?

Thanks
Varsha

 

[synapsevampire]

"Big query" is an unusual term, so I'm not sure what you mean by that, but a Stored Procedure usually has the advantage of having a pre-compiled execution plan available, so it will be faster.

But it's relative to what you're selecting.

-k