>What is the optimal number of tables in a database. I have a database with around 175 entities and observe a poor performance in terms of data fetching.
Have you cleaned up (PACKed) the DBC lately? You can get a potentially huge number of records if you make a lot of DB changes and don't pack it.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.