Have similar issue as was ask in other question.

In my case none of cases from microsoft docs seems to apply

Can something else be the reason? Schema changes not happening, but after index maintenance new plan is generated and forced one gets ignored.

enter image description here


  • has lot of joins and union. there is query hint used in joins (maybe that is the reson?)
  • select list contains "*"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.