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

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 / dinesh

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

List and explain the different types of join clauses supported in ansi-standard sql?

1356

Define overloaded procedure?

1082

What are analytical functions in sql?

1029

What is sql in java?

1090

What is a scalar value in sql?

1073

What is insert command in sql?

1131

How to avoid duplicate records in a query?

1008

what is the difference between char_length and length? : Sql dba

1045

What is program debugging?

1256

What is procedure explain with program?

1021

how many ways to get the current time? : Sql dba

1007

what is csv? : Sql dba

999

what is innodb? : Sql dba

1106

Can primary key be changed?

906

When should I use nosql database?

1008