Post reply

Relationships

  • November 1, 2005 at 3:21 pm

    #188242

    Do relationships between tables effect the performance of a join in a SQL Statement?

  • November 1, 2005 at 3:36 pm

    #601701

    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

    #601703

    thank you.

  • November 2, 2005 at 3:43 am

    #601781

    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