In a table i have columns A,B,C and i have a composite index on columns A,B if

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 / g sivanagaraju

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

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