Please replace 'Select * from...' with 'Select COL1,COL2,COL3 from...'. I did the same and it worked. Not sure about the exact reason.
-- View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/phoenix-explain-plan-not-showing-any-difference-after-adding-a-local-index-on-the-table-column-that-r-tp1996p2000.html Sent from the Apache Phoenix User List mailing list archive at Nabble.com.
