I am new to Phoenix and would like to know the following execution for the query:
Let’s say I. Have a table with columns as A,B , C. Now I have A to be primary key . I create a global secondary index on B. What is the execution of the following:
Select A,B from table where B=x. OR B=y Or B=z ; Will it result in index scan or full table scan?
can't guarantee this, but the global index in Phoenix is as per documentation for 'heavy read' usage. So if this should make sense, your query should result in using the secondary index (of course only when using Phoenix).