Fields with FOREIGN REFERENCES

[benasumwa]

Hi Friends,

I am preparing my table definitions and I
am just wondering about whether all fields
with FOREIGN REFERENCES to other tables should
be indexed. (SQL Sever 2000)

Any help?



---------------------------
Benson O. A.
Infinity Link Limited

 

[SQLDenis]

a primary is already a clustered index

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLDenis]

Slow down Denis!

a primary KEY is already a clustered index
when you make a column a primary key SQL Server will create a clustered index on that column for you

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[benasumwa]

Dennis,

Slow down Denis!

True!

In short you are saying I should not bother
creating indices on those fields?

Then again what if I'll be querying using those
fields, including them in the WHERE clause, is it
advisable to create indices on all of them?

Any help?


---------------------------
Benson O. A.
Infinity Link Limited

 

[SQLDenis]

What I am saying is that when you create a primary key then the index is already created for you

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/