A merged version of all my commits .

Added to note release.rst

Move shift_indexer into the shift function

Removed function _shift_indexer all together. Passes tests sparse.

remove unwanted comments
Merge pull request #6672 from gouthambs/iss5609

PERF: Quick Shift Implementation (GH5609)
ENH: define the order of resolution for index vs columns in query/eval
Merge pull request #6677 from cpcloud/index-resolvers-after-columns

ENH: define the order of resolution for index vs columns in query/eval