Relationship affect speed?

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referential integrity and join type 2
When to Create Separate Tables? 6
Cascade Delete Relationship Question 2
Importing relationship 11
Table Relationship for database 3
Too many indexes when creating relationship 7
issues on table with relationship to self 4
Relationship with a Primary Key? 4

Top