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
- 5472 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
what is foreign key? : Sql dba
how can we destroy the cookie? : Sql dba
Why triggers are used?
Can instead of triggers be used to fire once for each statement on a view?
What is an example of translating a date into julian format?
how are mysql timestamps seen to a user? : Sql dba
What is the difference between a primary key and a unique key?
how to enter numeric values as hex numbers? : Sql dba
what is the difference between delete and truncate commands? : Sql dba
What are the two types of exceptions.
Will truncate release space?
What is cursor in pl sql?
What is a temp table?
What are the benefits of triggers?
Is sql open source?
