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
- 5374 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
How to check if a column is nullable before setting to nullable?
What does partition by mean in sql?
What is the size of partition table?
How do I write a cron which will run a sql query and mail the results to agroup?
What are the dml statements?
What is rank () in sql?
what are the types of join and explain each? : Sql dba
What is the difference between execution of triggers and stored procedures?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
How do you identify a primary key?
Is sql similar to python?
What is primary key in db?
What is the difference between a primary key and a clustered index?
How to prepare for oracle pl sql certification?
What is meant by <> in sql?
