In the where clause of select query having the non primary key fields Select….where A And B And C .Created a secondary index having A field first and D field next .Will Select query uses this secondary index?