When you run queries on Lists and Libraries there are a couple of rules to observe when to use index on columns.

Index rules.
  • The general rule is NOT to use index on any columns.
  • Use index only when you want query a column in a large list and return <5000 items.

The reason for this is purely SharePoint CAML optimizer limitations.

Need more help with this?
DON'T HESITATE TO CONTACT US HERE ..

Thanks for your feedback.