Interested to Buy Any Domain ? << Click Here >> for more details...
What is Index and different types of Indexes?
- 7 Answers
- 36439 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
How to export data to a csv file?
what is the exact diiference between DBMS and RDBMS
How to write date and time literals in oracle?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
How to create a new oracle data file?
What are the components of physical database structure in the Oracle database?
How to Remove the 3rd highest salary person record from table?
what r tyhe major differences between oracle 9i & 10g?
Explain what does a control file contain?
How to get the Installed Oracle Version Information ?
what are steps for interface? where is exchange rate defined in which table?
Oracle General 
