Prospects, This is the Only place Where YOu can Find All Interview questions,Faqs and Real Stuff and scenario & Scripts with Resumes, Stick to It for Updates,,,,

Sunday, April 6, 2008

Improve performance of the reports

How can we improve performance of the reports?

Follow this Steps

1. Don’t use the Not in function in the query.

2. Check the Governor Settings.

3. Check the table qualifying and weighting.

4. Check the client/server balancing.

5. Avoid using complex calculations avoid complex reportcheck filter condition,use less filteravoid unwanted calculation.