|
Declaring primary key and foreign key relationships and their constraints can improve performance.
This is especially true when joins take place because the cost model is able to do a better job of estimation.
Not declaring the relationship can save time on index maintenance. Undeclared primary key-foreign key relationships exist between tables when there is an implied relationship between the values of columns in different tables.