Add index to table

you create another index, normally on just that column.

what is the exact issue you have?

There are normally two types of indexes - Clustered and non-Clustered. Primary keys normally create clustered index. So which type of index do you want to create on another column?

If you want to create nonclustered index then you can simply use

CREATE INDEX INDEX_NAME
on TABLENAME (COLUMN NAME)

angelIII:

I have a table that stores our media "mail history" ...actual addresses for bulk mail

the mailID is the primary key

Ive been asked to add an index on AddrID column

So if your table is called MailHistory you would use

CREATE INDEX idxAddrID
on MailHistory (AddrID)

malikirfan28: was first and Neilsr: was precise

Any problems with a 350/150 split?

Hey you can create a non cluster index on other than primary key. Same as cluster index

Create index Indexname on Table (Columnname)

malikirfan28
You have a  valid point