Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 are the differences between in and exists clause?

0 Answers  

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

Is it possible to pass parameters to triggers?

0 Answers  

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

What does “select count(1) from tab” result?

10 Answers   IBM,

How to create an array in pl/sql?

0 Answers  

What is use of package in pl sql?

0 Answers  

What are different functions in sql?

0 Answers  

What is trigger types in sql?

0 Answers  

define sql insert statement ? : Sql dba

0 Answers  

Is sql a oracle?

0 Answers  

How to trace the errors in pl/sql block code?

5 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories