HiveBrain v1.2.0
Get Started
← Back to all entries
patternModerate

How are indexes represented in an ERD?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
representedareindexeshowerd

Problem

What do indexes look like in an Entity Relationship Diagram?

I've googled it and I'm unsure what the standard look of an index is in an ERD. And I'm talking about the crowsfoot diagram that includes all of the fields.

Solution

They don't tend to be shown in ERDs. An ERD focuses on the Entities and their Relationships, but an index is a copy of the data from one (or potentially more) of the entities, created to assist in the execution of queries. While it's possible that an index could be unique and therefore contribute to the database design, they are not typically shown on ERDs.

...which is a shame, because in my experience, a database design should involve careful acknowledgement of the indexes, as they can make-or-break the effectiveness of a database system.

Context

StackExchange Database Administrators Q#23610, answer score: 10

Revisions (0)

No revisions yet.