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
- 4943 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 ttitle and btitle?
What is left inner join in sql?
Does sql view stored data?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What are string functions in sql?
What is 19 null in sql?
What is the difference between count 1 and count (*) in a sql query?
How do I run pl sql in sql developer?
How do you determine the current isolation level? : Transact sql
Describe different types of general function used in sql?
What is denormalization in a database?
What are pl/sql cursor exceptions?
How insert into statements in sql?
How to display Row Number with Records in Oracle SQL Plus?
Is truncate ddl or dml?
