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?

Keep practicing — related questions

• For which relational operators in where clause, index is not used ?
• Index will not be used if ... Choose all that apply.
• While creating a table Primary key is defined but not Primary Index, then this will be considered as Primar...
• While creating a table Primary key is defined but not Primary Index, then this will be considered as Primar...
• The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associ...
• Can the ORDER BY clause use column index of the select clause to sort the fetched records.
• What is not true about the primary index of a table
• The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associ...