topic Re: SAP table view performance in Application Development and Automation Discussions

SAP table view performance

Former Member — Thu, 02 Nov 2006 17:14:30 GMT

Dear friends,

We have a table view with two tables inner joined and each table has more than 30 million records. It gets time out every time when trying a full load, even in batch mode the temp table got full and throw and short dump. Any good idea to improve the performance? Would indexing the join key be helpful?

Thanks in advance,

-Calvin

Re: SAP table view performance

Former Member — Thu, 02 Nov 2006 17:32:16 GMT

I've never tried to insert data into a view, but if you must do it this way, then yes you have to have an index on the join fields.

But why don't you just load the tables individually?

Rob

Re: SAP table view performance

Former Member — Thu, 02 Nov 2006 17:52:03 GMT

Thanks Rob...

We aren't inserting data in the view. Actually the view is for a BW data load.

-Calvin

Re: SAP table view performance

Former Member — Thu, 02 Nov 2006 17:59:35 GMT

Well, you should still join on index fields.

30 million records will take time to load. I doubt if the load is dumping (in background) because of that. It's more likely running the rollback segment out of space.

In any event, try loading in smaller chunks with a commit in between chunks.

Rob