Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How translate command is different from replace?
What is the difference between pre-select and pre-query?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
what are the default admin accounts in Oracle 10g ?
How do we get field detail of a table?
How remove data files before opening a database?
Explain the use of grant option in exp command.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to start your 10g xe server from command line?
What is meant by recursive hints in oracle?
How to end the current transaction in oracle?
How to invoke the data pump export utility?
What is clustered table in Oracle?
WHAT IS ecc 6.0
