I am looking for the wisdom of the crowd. I have six tables, one main table A and five other tables that describe some additional dimensions of table A.; For instance, the A table describes a page and table AB describes devices used to view this page. So it is one too many relationships. It is a “star schema” with A being in the center.
So the data distributions look like the following
A: 0.5M records
AB: 1M records
AC: 10M records
AD: 5M records
AE: 20M records
The query is doing left joins to get a denormalized view for each records filtering by several parameters on A, such as a date, location, etc.
The question is what the reasonable performance I can get is? When each record in A have about 100 of related records in other tables? The primary keys join the tables.