Answer Posted / elbert gopta
An index is an additional auxiliary access structure used to speed up the retrieval of records in response to certain search conditions
An index enables efficient access to a record based on the indexing field or fields
An index is an ordered file with two fields consisting of the indexing field and the physical address of the record/block
Each table typically has a primary index created for the primary key of the table.
Types:
Primary Index
Secondary Index
Multilevel indexes
B-tree and B+-tree indexes
| Is This Answer Correct ? | 13 Yes | 5 No |
Post New Answer View All Answers
How to use "while" statements in oracle?
What is truncate oracle?
What are the predefined tablespaces in a database?
Explain parameter file in oracle.
How to shutdown your 10g xe server?
What are set operators?
What is an oracle user account?
How would you go about verifying the network name that the local_listener is currently using?
what is the difference between data migration and production migration.
What is Java Pool in Oracle?
Can multiple cursors being opened at the same time?
How to recover a dropped table in oracle?
How to drop an existing table in oracle?
How to convert characters to dates in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
