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

Describe the Index, Types of index, At what situation we
have used? Which one s better than others?

Question Posted / ecesathish_2005


Describe the Index, Types of index, At what situation we have used? Which one s better than others?..

Answer / oraclem

Index is a DB object that makes data retrieval faster.Index created on column and that column is called index key.
Types of index:
1)BTREE Index
2)BITMAP index
Purpose of creating INDEX: Oracle will take more time to locate the record,to improve the performance of the quesry we have to create the Index.
IF we do not mention the type of index,by default oracle will take BTREE as default Index.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is scalar and vector?

0 Answers  

Is mariadb nosql?

0 Answers  

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

How do I view tables in mysql?

0 Answers  




select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

What is cte?

0 Answers  

What is the use of %rowtype?

0 Answers  

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

When do we create bitmap indexes

2 Answers   CTS,

can we create index on index?

7 Answers   iFlex, Symphony,

How do you sort in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories