Skip to Content
author's profile photo Former Member
Former Member

DB View Performance enhancement

Hi All,

Client has a database view for a generic extraction of master data that has been running for sometime. It is a daily full load, which gets in records somewhere around 500,000 to 800,000 records. Now the complaintis that the load takes a long time and the window they have is

just 6hrs. He wants to investigate the view and see what can be done to minimize the load time.

Can someone tell me what are the best ways to make the view effective?

Is there any other way of generic extraction that would be more effective than the view?

is there any tweaking that needs to be done to enhance the load performance?



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2005 at 12:04 AM


    First check if you can split the load into small selections and do a parallel loads. Do the change run at the end of these loads. Make sure there is enough memory in the source system to handle all four jobs at the same time.

    On the source system tables check if your are running any statistics, else run statistics on these base tables.

    Also check table entries for ROIDOCPRMS - Control parameters for data transfer from the source system. Check with basis if you can increase the parallel Processors to speed up the extraction process.

    These are just few initial stepsÂ…

    Hope this helps..


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2005 at 06:48 AM

    Hi Mav,

    take a look at the SQL statement execution of the extraction with ST05 trace option. It should put in evidence where it looses time ...

    Hope it helps


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.