View Vs Join

[Former Member]

Dear Experts,

What is the best way of improving the performance in a selection, VIEW(creating a DB View) or JOIN (Joining the DB Tables)?

Thanks,

Bala

[christian_wohlfahrt]

Views might be cached by application servers, joins are always accessed by database directly.

But most times joins (/views) are anyway complex and need a lot of entries -> caching is not useful.

Different approach (especially, when some indices are not used which you would prefer): select first table(s) into an internal table, read the rest 'for all entries' (which again is not cached).

Christian

[eddy_declercq]

Perfomance is more determined by the way you define the tables (keys, order of fields in select, etc.) More info at service.sap.com/performance.

PS Donn't forget to reward the answers with these yellow stars;-)

Message was edited by: Eddy De Clercq

[ChristianFi]

Christian,

there is no way to buffer views on application level (SAP Table Buffering) - is there?

At least I have always missed the technical settings button, so I assumed it would not be possible.

Christian