November 1, 2005 at 3:21 pm
Do relationships between tables effect the performance of a join in a SQL Statement?
November 1, 2005 at 3:36 pm
By "relationships", do you mean foreign key constraints ?
If so, then not with SQL Server.
SQLAnywhere does do special indexing when a foreign key constraint is defined. The special indexing does have scalability side-effects.
P.S.
"relational" in a relational database means the dependencies between the primary key and the non-primary key columns.
SQL = Scarcely Qualifies as a Language
November 1, 2005 at 3:40 pm
thank you.
November 2, 2005 at 3:43 am
You should have indices on the fields on either side of the join to increase its performance - having a FK defined doesn't define an index for you..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply