Measure query performance before you create the index. Record the stats (and you should have some idea what queries you're tuning)
Add the index
Measure query performance again.
Compare.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability