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?