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
Name the three major set of files on disk that compose a database in Oracle?
What are joins, explain all types of joins?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to create a new user account in oracle?
What are a query and state the different types of queries and their uses?
how may join possible between (requisition with purchase order)
Is postgres faster than oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
what are archived logs?
Explain temporal data types in oracle
Explain the different normalization forms?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to install oracle odbc drivers?
