Definitely creating two indexes on the same table on the same field is a wrong decision! Do any of you have another opinion?
Can any one provide me with any article that mentions the disadvantages of such thing?
I actually was wondering about something regarding this recently.
Sometimes you may want to create an index as part of a column (say the first 10 characters). Would it then be an idea to create both the partial index and the full index, and use them in any query where appropriate?
If you are going to create a clustered index using the same field that is already indexed as the primary key, don't make that field the first column of your clustered index, otherwise I can't see how you get a lot of advantage from it. If you make it a secondary column, then at least the optimizer has a choice of two index orders for sorting and searching.