Field relation vs performance

G

GL

Hi,

I use a database that includes two tables having two fields related with a
one-to-many relation. The join is set to include all records from 'Table1'
and only those records from 'Table2' where the joined fields are equal. That
relation is not absolutely necessary for the integrity of the database so I’m
wondering if is worthwhile to delete the relation if it is going to give
better performance.
The database will not have more than several thousands of records in full
use, if it makes any difference.
What is your opinion about this?

Thank you

GL
 
R

Rick Brandt

GL said:
Hi,

I use a database that includes two tables having two fields related
with a one-to-many relation. The join is set to include all records
from 'Table1' and only those records from 'Table2' where the joined
fields are equal. That relation is not absolutely necessary for the
integrity of the database so I'm wondering if is worthwhile to delete
the relation if it is going to give better performance.
The database will not have more than several thousands of records in
full use, if it makes any difference.
What is your opinion about this?

Thank you

GL
Click to expand...

Deleting the relation would more than likely make performance worse, not
better.
 
Top