Data retrieval from 8 db tables
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,