creating an index

[eja2000]

i have a table with several rows..i want to create a key on a field that i wil include in my WHERE sql statements..the field will not be a primary key but the degree of uniqueness will be very high..

What i mean is that there may be a few fields in the table
with the same value for this field but generally the degree of uniqueness is 95%.i have an autoincrementing integer primary key on the table but i doesnt appear in sql statements..

can u show me how to create this index in TSQL and what will it be (clustered or non clustered)?
Thx

 

[nigelrivett]

Look at create index in bol.

create index ix on tbl
(fld1, fld2, fld3)



======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[eja2000]

will it affect existing data?
i have about 5000 rows in there..