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
Explain the use of ignore option in imp command.
Explain the use of online redo log files in oracle.
why dont we assign not null constraint as table level constraint.
What is background process in Oracle?
What do you understand by a database object?
How to sort output in descending order in oracle?
What's dateware house and what's clustor with practicle example
How to define an anonymous procedure without variables?
what is the difference between data migration and production migration.
How to define a sub function?
What is a cursor and what are the steps need to be taken?
What is the difference between post-database commit and post-form commit?
What is the database name in oracle?
if you ctreate table identity
How to download oracle database 10g xe?
