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
What is the use of aggregate functions in oracle?
definition of cluster and non-clustered index?
How does the on-delete-cascade statement work?
What is connection pool in oracle?
What privilege is needed for a user to create indexes in oracle?
How do I connect to oracle database?
What privilege is needed for a user to connect to oracle server?
What happens to the current transaction if the session is killed?
What is a parameter file in oracle?
What is tns entry?
What are the parameters that we can pass through a stored procedure?
Explain the use of show option in imp command.
Is it possible to insert comments into sql statements return in the data model editor ?
What is the difference between hot backup and cold backup in oracle?
Can we commit inside a function in oracle?
