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
- 5511 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
What is pragma in pl sql?
What are tuples in sql?
What are pl/sql packages?
What is the execution plan in sql?
What are the ways on commenting in a pl/sql code?
What is file based approach?
How can we avoid duplicating records in a query?
What is the difference between delete and truncate statement in sql?
What is pessimistic concurrency control? : Transact sql
What are sql objects?
What is the clause we need to add in function body to return variable?
What is a dirty read sql?
what are the differences between binary and varbinary? : Sql dba
How to get each name only once from an employee table?
How to Execute a Package in PL/SQL.?
