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
- 4942 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
What does dml mean?
Can a varchar be a primary key?
What is triggering circuit?
Where is pl sql used?
How to use distinct and count in sql query? Explain
How many sql core licenses do I need?
Does view contain data?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
how to drop an existing index in mysql? : Sql dba
Can we use join in subquery?
What is a database event trigger?
What are crud methods?
What is interval partition?
How to find 3rd highest salary of an employee from the employee table in sql?
What is the difference between a primary key and a clustered index?
