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>;
Answers were Sorted based on User's Feedback
Answer / 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 |
What is output spooling in sql*plus?
What will you get by the cursor attribute sql%notfound?
how many tupples can insert in 1 second in sql
How many triggers can be implemented for a table?
What is union?
what is the order of pre-defined exceptions.
What is nested table in pl sql?
What will you get by the cursor attribute sql%found?
What is the difference between clustered and non-clustered indexes?
What does count (*) do in sql?
Explain the difference between sql and mysql.
How does one load ebcdic data? : aql loader