In a table i have columns A,B,C and i have a composite index
on columns A,B if so will the following query uses index or
not?
SELECT sal,name
FROM <table_name>
WHERE A=<value> AND B=<value> AND C=<value>;

Answers were Sorted based on User's Feedback



In a table i have columns A,B,C and i have a composite index on columns A,B if so will the followi..

Answer / kishore vakiti

index range scan

Is This Answer Correct ?    1 Yes 1 No

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the followi..

Answer / dinesh

Table Access (BY INDEX ROWID)
Filter predicates C=
INDEX(UNIQUE SCAN) A= B=

Here we use "AND" operator that query used index
if we used "OR" its not used Index scan

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the location of pre_defined_functions.

0 Answers  


What is parallel hint?

0 Answers  


what are different types of collation sensitivity? : Sql dba

0 Answers  


display null value rows with out using null function?

8 Answers   Infosys,


What does where 1 1 mean in sql?

0 Answers  






Types of cursors and explanation each of them ?

4 Answers   DELL,


What is a pl/sql block?

0 Answers  


Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  


How can u find column name from a table which have max value in a row.( not max value)

5 Answers  


What are the types of variable use in pl sql?

0 Answers  


Differentiate pl/sql and sql?

0 Answers  


What are the types of operators available in sql?

0 Answers  


Categories