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
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
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.
B-tree and B+-tree indexes
|Is This Answer Correct ?||13 Yes||5 No|
Answer / manvendra
PHYSICAL OR LOGICAL LISTING OF COLUMN TO SPEEDUP THE SEARCH
IN A TABLE OR VIEW IS CALLED INDEX.
FUNCTION BASED 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.
|Is This Answer Correct ?||4 Yes||6 No|
Answer / joe
4 different types of index
|Is This Answer Correct ?||1 Yes||5 No|
What is the fastest query method to fetch data from the table?
Difference between primary key and unique key ?
What is the difference between 10g OEM and 11g OEM?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
is database gud carrier option??
How to store pictures on to the database?
How to use in conditions in oracle?
select statement does not retrieve any records. what exception is raised?
How you open and close a cursor variable.Why it is required?
What is the difference between translate and replace in oracle?
Explain the use of indexes option in exp command.
How to retrieve data from an cursor to a record?