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
Explain the use of parfile option in exp command.
Explain the use of record length option in exp command.
What is a partition in oracle?
What is merge in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to define and use table alias names in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is tns name?
What are the differences between blob and clob in oracle?
What are the different oracle database objects?
Difference between the “verify” and “feedback” command?
Explain the use of compress option in exp command.
How to divide query output into groups in oracle?
What do you understand by a database object?
Why do we need integrity constraints in a database?
