Sign Up Login


  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

how to write date and time literals? : Sql dba

0 Answers  

Explian rowid, rownum?

0 Answers  

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

Is sql a programming?

0 Answers  

What is difference between nchar and nvarchar?

0 Answers  




What is a common use of group by in sql?

0 Answers  

What is sql resultset?

0 Answers  

Define select, insert, create, delete, update, drop keywords

0 Answers  

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

What is mutating error?

0 Answers  

When do we use triggers?

0 Answers  

What is the difference between the conventional and direct path loads? : aql loader

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories