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.

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

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

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

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

Answer / joe

4 different types of index

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

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)

What is Library Cache in Oracle?

0 Answers   MCN Solutions,

How to find out what oracle odbc drivers are installed?

0 Answers  

What are various constraints used in SQL?

1 Answers   Polaris,

What is the difference between normal and corelated subqueries?

2 Answers  

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

How to rename an existing table?

0 Answers  

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

1 Answers   Infosys,

How do you handle duplicate records in a database?

1 Answers  

What is a private synonym?

0 Answers  

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

How to run the anonymous block again?

0 Answers  

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,