In sql server it depends on what column query engine uses. The retrieval performance has no direct relationship with number of indexes present. However any DML operation on the table might get slower on addition of new indexes. The query analyser will just see whats the easiest way of finding record based on search fields used. Based on it, it may choose to traverse the actual table (or clustered index if present) or traverse the nonclustered index table.