Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are the attributes that are found in a cursor?
How will you identify oracle database software release?
What is the difference between truncate & delete command?
What do you understand by a database object? Can you list a few of them?
How can we find out the duplicate values in an oracle table?
How to call a sub procedure?
Is postgres faster than oracle?
How to open and close an explicit cursor in oracle?
How can we create the complete backup of data in the oracle.
What to do if the binary spfile is wrong for the default instance?
candidate key is subset of super key but not vice-verse explain
What is Java Pool in Oracle?
What do you mean by a tablespace?
How to update a table row with a record?
why dont we assign not null constraint as table level constraint.
