Relationship affect speed?

  • Thread starter Thread starter Petr Danes
  • Start date Start date
P

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
 
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.
 
Back
Top