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
- 4531 Views
- Mastek, I also Faced
- E-Mail Answers
Answer Posted / kishore vakiti
index range scan
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Is a secondary key the same as a foreign key?
How is sql used in oracle?
How does sql profiler work?
What is the primary use of normalization?
How do you take the union of two tables in sql?
what is 'mysqladmin' in mysql? : Sql dba
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What is the usage of when clause in trigger?
How can we debug in PL/SQL?
what is the stuff function and how does it differ from the replace function? : Sql dba
Is postgresql a server?
How does a self join work?
What is data modelling in sql?
when is the use of update_statistics command? : Sql dba
Can procedure in package be overloaded?
