Hi Ankit,
I think this is not completely true.
Phoenix uses local index table when all columns in where clause and atleast one column in select clause are part of local index table.
"Select col1,col2,col3 from table" uses local index but "select * from table" do not.
I'm not certain of
Hi Vamsi,
*Explain plan:*
explain select * from vamsi.table_a where col2 = 'abc';
+-+
|PLAN |
+-+
| CLIENT 5-CHUNK
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: