ERD

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

ERD

Roshan
This post was updated on .
Hi Erman,

I have imported a dump file on a 12.1.0.2 DB. I have generated the ERD.

Could you please advise what information I can gather from an ERD?

 Relational_1.pdf

What tunings can be done as per this ERD?

Do we need to know the number of rows which are loaded in each tables for capacity planning?

Thanks,

Roshan
Reply | Threaded
Open this post in threaded view
|

Re: ERD

ErmanArslansOracleBlog
Administrator
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)