I would answer this for you, but it is easy enough to set up and test. Look at the execution plans both before and after the index...