Hm. Run some queries; drop the second version of the index definition; re-run the same queries; report to the group. The redundant index isn't helping, that much is certain.
On 10/20/2010 05:43 PM, DM wrote: > Composite Index question: > > I have composite index on 3 columns on a table, by mistake the composite > index was created twice on the table. > > Will there any performance issues on this table because of the 2 same > composite indexes? > > Thanks > Deepak