Skip to Content
Former Member
Oct 12, 2006 at 08:15 PM

Reg Query Optimization - doubts..


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.



Message was edited by: Gaurav