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 oracle differences between nvl and coalesce
How to connect ms access to oracle servers?
Explain the use of constraints option in exp command.
Explain an index segment?
What are the set operators union, union all, minus & intersect meant to do?
What is the difference between a primary key & a unique key?
What is flashback in Oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Explain an integrity constrains?
How to write a left outer join with the where clause in oracle?
How can we find out the duplicate values in an oracle table?
What is a read only transaction in oracle?
Can we commit inside a function in oracle?
What do you mean by merge in oracle and how can you merge two tables?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
