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



In a table i have columns A,B,C and i have a composite index on columns A,B if so will the followi..

Answer / kishore vakiti

index range scan

Is This Answer Correct ?    1 Yes 1 No

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the followi..

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

Post New Answer

More SQL PLSQL Interview Questions

What is output spooling in sql*plus?

0 Answers  


What will you get by the cursor attribute sql%notfound?

0 Answers  


how many tupples can insert in 1 second in sql

1 Answers  


How many triggers can be implemented for a table?

3 Answers   HSBC,


What is union?

0 Answers  






what is the order of pre-defined exceptions.

6 Answers   TCS,


What is nested table in pl sql?

0 Answers  


What will you get by the cursor attribute sql%found?

0 Answers  


What is the difference between clustered and non-clustered indexes?

0 Answers  


What does count (*) do in sql?

0 Answers  


Explain the difference between sql and mysql.

0 Answers  


How does one load ebcdic data? : aql loader

0 Answers  


Categories