In a table i have columns A,B,C and i have a composite index on columns A,B if

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>;

Question Posted / g sivanagaraju

2 Answers
5530 Views
Mastek, I also Faced
E-Mail Answers

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 are the different types of dbms?

0 Answers

Are null values same as that of zero or a blank space?

0 Answers

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers

What is the difference between SQL and PLSQL

7 Answers IBM,

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers

select 1,col1,col2 from table1. output?

5 Answers Ramco,

What are the benefits of pl sql?

0 Answers

cursor types? explain with example programs?

1 Answers HP,

Why trigger is used in sql?

0 Answers

What is scalar and vector?

0 Answers

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers TCS,

What is pl sql block structure?

0 Answers

For more SQL PLSQL Interview Questions Click Here