Re: ERD

Posted by ErmanArslansOracleBlog on Oct 14, 2020; 11:18am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ERD-tp8862p8863.html

ER diagram is a well known thing.

Basically, it may help you to see the logical structure of your db/schema, its tables and the relation between them. You may use that info from ER diagram to have a more efficient logical db design by reducing columns and achieve normalization. I mean to clear the database from unused data and to reduce the data redundancy and inconsistency.
It also may be used while tuning the complex query.. (because you need to see the general logical structure to tune or rewrite a complex query)