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
- 5474 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
Can you select everything, but 1 or 2 fields, without writer's cramp?
What are the two virtual tables available at the time of database trigger execution?
What is the best sql course?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How many types of cursors supported in pl/sql?
what is blob? : Sql dba
How do you declare a variable in pl sql?
What problem one might face while writing log information to a data-base table in pl/sql?
How can we find duplicate records in a table?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What are crud methods?
difference between anonymous blocks and sub-programs.
How many triggers can be applied to a table?
What sql does db2 use?
What is cte sql?
