Reg Query Optimization - doubts..

[Former Member]

Hi Experts,

This is related to Blog by Mr Prakash Darji regarding "Query Optimization" posted on Jan 26 2006.In this to optimize query Generation of Report is suggested.

I tried this, but I am not sure I am analyzing this correctly.

I collected Stats data before and after Generation of Report.But how to be sure that this is helping me? Did any one has tried this?

What to look for in Stats Data - duration?

But duration would not be absolute parameter as there is factor of "Wait Time, User", so duration may depend on this.

Please help me in this.

Thanks

Gaurav

Message was edited by: Gaurav

[Former Member]

Any ideas Experts?