Skip to Content
0
Former Member
Sep 29, 2005 at 11:21 PM

DB View Performance enhancement

30 Views

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?

Thanks,

Mav.