SAP table view performance

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks Rob...

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

-Calvin

[Former Member]

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