Hi

(SQL Server 2005)I have a huge table "Articles" that contains over than one million records and I need to fasten the search.
the field of this table are:
ArticleID int
Title nvarchar(100)
Author nvarchar(100)
Filename varchar(50)
KeywordID int
ArticleDate datetime

I usually search this table by its Filename and/or KeywordID and/or ArticleDate
so i thought i should add indexes on those fields but i don't know what type of indexes should I add and how.

Could anyone give me an example?

thanks