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 do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is a database schema in oracle?
What are the advantages of oracle?
Hi Can any one tell me what are the API's used in requisition import.
1) Does oracle have any table which contain all the exceptions and it's code internally?
How do I connect to oracle database?
What are the differences between number and binary_float in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Explain the use of record length option in exp command.
What is the usage of control file in oracle?
What is a table in oracle?
How to drop an existing table in oracle?
How many types of tables supported by oracle?
Name the three major set of files on disk that compose a database in Oracle?
How to load data from external tables to regular tables?