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

What is the command used to fetch the first 5 characters of a string?

1260

what is the difference between blob and text? : Sql dba

1064

what happens if null values are involved in expressions? : Sql dba

1093

what is 'mysqladmin' in mysql? : Sql dba

1076

What is sql*loader and what is it used for?

1222

How do I copy a table in sql?

1037

How can I speed up sql query?

1008

What are sql indexes?

1046

Is oracle and sql same?

1078

How do I make my sql query run faster?

1018

What is the maximum number of triggers, you can apply on a single table?

1048

Advantages and disadvantages of stored procedure?

1169

Are sql connections encrypted?

1088

Why do we use partitions in sql?

1096

What is #table in sql?

1182