Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data retrieval from 8 db tables

Hi Folks,

We haev a requirement where we need to query 7 tables to retrieve some data and display it in the form of a list.

This report is to be executed in background.

Right now we have 3 select statements, each of which has inner joins on 2-3 tables and uses "for all entries".

Performance wise which would be a better option - to keep it this way, or have separate select statement for each table and then read statements on internal tabels for output?

Thanks in advance,


Not what you were looking for? View more on this topic or Ask a question