Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

despite the fact that the query explicitly excludes rows where VAT_CALC_AMT is zero.
If the index is dropped it doesn't ( and the query plan changes).
Also, if the query is changed to add a bogus condition "A.OPERATORNAME <> 'Non existent user'", it also works normally.