Adding Indexes to Table

I'm looking for information on how to add indexes to a table in a SQL Server 2000 Database, why add them etc? Any source of good information on the web regarding this?

Hi,

I've been looking for this kind of info too. I have a feeling, and I think I have read somewhere, that the indexing is more or less automatic in SqlServer 2000 and that's why one can't find out how to do it. However, someone else would need to verify this...

Pettrer

|||

...indexes to a table ... why add them?

Lookup speed. Imagine using a dictionary that wasn't in alphabetical order...

|||And how could i use Enterprise Manager to add them to a table?|||

Hi again,

As I suspected, these are being set automatically for me (in SqlServer Management Studio Express) and are displayed in the "column properties" section. I guess the same goes for Enterprise manager.

Pettrer

|||

pettrer:

Hi again,

As I suspected, these are being set automatically for me (in SqlServer Management Studio Express) and are displayed in the "column properties" section. I guess the same goes for Enterprise manager.

Pettrer

I suspect this is a non clustered index. I was looking at how to explicitly set an index based on the execution plan.

|||

Hi,

To create index, you will need to use CREATE INDEX statement.

The syntax can be found from

http://msdn2.microsoft.com/en-us/library/ms188783.aspx