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 best way to do multi-row insert in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is ASM (Automatic Storage Management) in Oracle?
Why we use bulk collect in oracle?
How do I connect to oracle database?
What to do if the binary spfile is wrong for the default instance?
What are the different types of modules in oracle forms?
Can you create a synonym without having a table?
How to use "for" statements in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is using clause and give example?
Point the difference between translate and replace?
How to set up autotrace for a user account?
Explain about the analyze command in oracle?
What is a dead lock in oracle?
