Please post this in mysql or postgres forums..this is a sql server related forum. not sure if the database indexing architechture for all these is same.
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.
Indexing
Posted - 04/23/2013 : 01:04:28
