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
- 5495 Views
- Mastek, I also Faced
- E-Mail Answers
Answer Posted / dinesh
Table Access (BY INDEX ROWID)
Filter predicates C=
INDEX(UNIQUE SCAN) A= B=
Here we use "AND" operator that query used index
if we used "OR" its not used Index scan
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is sql developer case sensitive?
What is difference between inner join and cross join?
what are the types of subquery? : Sql dba
What is delete command in sql?
What is tuple in sql?
How bulk collect improves performance?
What is a database trigger?
What is %rowtype in pl sql?
Why self join is used in sql?
What are pl/sql cursor exceptions?
What is a Mapplet?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Why is the cursor important?
What is nvarchar max in sql?
what is oltp (online transaction processing)? : Sql dba
