Interested to Buy Any Domain ? << Click Here >> for more details...
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>;
- 2 Answers
- 5369 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
explain the difference between myisam static and myisam dynamic. : Sql dba
What is a pragma statement?
What are the three forms of normalization?
What is the basic structure of an sql?
What are field types?
How to check if a column is nullable before setting to nullable?
What is sql rowcount?
How many sql are there?
What are its different types of dbms?
what is 'mysqlimport'? : Sql dba
Does sql backup shrink transaction log?
what are all different types of collation sensitivity? : Sql dba
What is rowid in sql?
what is the difference between where clause and having clause? : Sql dba
What is trigger in pl sql with examples?
