Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is Index and different types of Indexes?

Answers were Sorted based on User's Feedback



What is Index and different types of Indexes?..

Answer / alcheringa

indexes is a process of creating a structure from a
database table from a single or multiple compostion
(atleast) of attributes for efficient data retreival.
some database even allow to create indexes out of
expressions as well.

there are different types of indexes based on the
implementation methodology:
b Trees, b+ trees, bitmap indexes, hash index etc . infact
in some database the index file is different from the
database file and hence one can write one's plug in for a
special kind of index .

clustered and non-clustered is the kind of architecture
that is used to define the index methodology as noted
earlier.

indexes are boon when used in retreivals and they are
doomed when used in situations where there's more write
than read. this is so because every new write in the table
also implies corresponding modofication in the indexes as
created for the table.

Is This Answer Correct ?    22 Yes 5 No

What is Index and different types of Indexes?..

Answer / elbert gopta

An index is an additional auxiliary access structure used to speed up the retrieval of records in response to certain search conditions
An index enables efficient access to a record based on the indexing field or fields
An index is an ordered file with two fields consisting of the indexing field and the physical address of the record/block
Each table typically has a primary index created for the primary key of the table.

Types:
Primary Index
Secondary Index
Multilevel indexes
B-tree and B+-tree indexes

Is This Answer Correct ?    13 Yes 5 No

What is Index and different types of Indexes?..

Answer / muralidharan

Index is used to fetch the data in a reliable and fast
manner and the types of index avalilable are clustered
index and non clustered index.

Murali
dharanmu@yahoo.com

Is This Answer Correct ?    13 Yes 8 No

What is Index and different types of Indexes?..

Answer / manvendra

PHYSICAL OR LOGICAL LISTING OF COLUMN TO SPEEDUP THE SEARCH
IN A TABLE OR VIEW IS CALLED INDEX.

FUNCTION BASED INDEX
HASH INDEX
BITMAP INDEX
COMPOSIT INDEX
B TREE INDEX

Is This Answer Correct ?    8 Yes 9 No

What is Index and different types of Indexes?..

Answer / akriti sengar

in index we can write the summary of anything in a tabular form.
there are different type of indexes are as follows.
1.b trees
2.b+trees
3.bitmap indexes

Is This Answer Correct ?    4 Yes 6 No

What is Index and different types of Indexes?..

Answer / joe

4 different types of index

1.Clustered
2.Non Clustered
3.Primary XML
4.Spatial

Is This Answer Correct ?    1 Yes 5 No

What is Index and different types of Indexes?..

Answer / suresh somayajula

Index is used to solve some query fast.

we have 2 types of cursors.
1 Bitmap Index ( used only on Low cardinality columns)

2. Btree Index ( used only for High Cardinality of

columns)

Is This Answer Correct ?    8 Yes 18 No

Post New Answer



More Oracle General Interview Questions

What is the fastest query method to fetch data from the table?

0 Answers  


Difference between primary key and unique key ?

77 Answers   Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,


What is the difference between 10g OEM and 11g OEM?

0 Answers   MCN Solutions,


Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 Answers  


is database gud carrier option??

1 Answers  






How to store pictures on to the database?

0 Answers  


How to use in conditions in oracle?

0 Answers  


select statement does not retrieve any records. what exception is raised?

2 Answers  


How you open and close a cursor variable.Why it is required?

2 Answers  


What is the difference between translate and replace in oracle?

0 Answers  


Explain the use of indexes option in exp command.

0 Answers  


How to retrieve data from an cursor to a record?

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)