index range scan

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>;

Question Posted / kishore vakiti

2 Answers
5498 Views
Mastek, I also Faced
E-Mail Answers

Answer Posted / kishore vakiti

index range scan

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is a view? : Sql dba

1076

What language is oracle sql developer?

995

What are tables and fields?

1027

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1116

How can one get sql*loader to commit only at the end of the load file? : aql loader

1053

What does := mean in pl sql?

1038

What is foreign key and example?

927

what is a tablespace? : Sql dba

1046

How do I find duplicates in a single column in sql?

1012

what is text? : Sql dba

1065

Enlist the characteristics of pl/sql?

1791

What happens when a trigger is associated to a view?

904

What are all the different types of indexes?

1145

How to display Row Number with Records in Oracle SQL Plus?

1037

What is self-join and what is the requirement of self-join?

1145