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 the location of pre_defined_functions.
What is parallel hint?
what are different types of collation sensitivity? : Sql dba
display null value rows with out using null function?
What does where 1 1 mean in sql?
Types of cursors and explanation each of them ?
What is a pl/sql block?
Explain the usage of WHERE CURRENT OF clause in cursors ?
How can u find column name from a table which have max value in a row.( not max value)
What are the types of variable use in pl sql?
Differentiate pl/sql and sql?
What are the types of operators available in sql?