I am writing an extensive query and have multiple non-clustered indexs on a table.
I have one index for a single column [Column1] and another index for [Column2], [Column1].
I am using different querys where I sometimes just use [Column1] and other times use many columns including both [Column1], and [Column2].
My question is: If you have multiple indexes that contain the same column will they ever cause a conflict?
View Complete Post