Relationship affect speed?

[Petr Danes]

I'm trying to tweak maximum speed out of a db and am wondering about
relationships. I know that an index is created and so on, but what I'm
curious about is if the actual RELATIONSHIP has any effect on things. This
is a read-only db, with all data generated by code, so referential integrity
is not an issue. If I create my own indexes and omit the relationship lines,
would I see any significant difference in either retrieval speed or initial
population speed?

Pete

 

[Arvin Meyer [MVP]]

A relationship is the most efficient way to get data from more than 1 table,
and does not affect the speed of a single table. Indexes are only
detrimental in large append queries, where in some instances, it is more
efficient to drop the index, append the data, the recreate the index.