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

How is pl sql different from sql?

1144

what is acid property in database? : Sql dba

1071

Name three sql operations that perform a sort.

1066

What is rowid in sql?

1056

Which command is used to delete a trigger?

1407

what is the difference between where clause and having clause? : Sql dba

1046

Is sqlexception checked or unchecked?

1013

What is sql and explain its components?

1119

Why trigger is used in sql?

1017

What is execute immediate?

1163

What is primary key and foreign key?

1014

what is a record in a database ? : Sql dba

1105

Can we change the table name in sql?

1005

How to Execute a Package in PL/SQL.?

1288

what is a database transaction? : Sql dba

1258