1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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

How do you explain an index number?

0 Answers  

What is sql mysql pl sql oracle?

0 Answers  

what are aggregate and scalar functions? : Sql dba

0 Answers  

What are the operators used in select statements?

0 Answers  

What is rownum and rowid?

0 Answers  




Which are the most commonly used sql joins?

1 Answers  

how to convert character strings to dates? : Sql dba

0 Answers  

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

What is the source code of a program?

0 Answers  

Explain autonomous transaction.

0 Answers  

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

What is your daily office routine?

0 Answers   Data Vision,

For more SQL PLSQL Interview Questions Click Here
Categories