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 exactly do quotation marks around the table name do?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
query optmization techniques and quwry analyser+projects+ppts
What is an oracle user account?
What is the maximum limit on the number of columns in a table?
Explain the importance of .pll extension in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
What is the use of oracle?
How do I find my oracle client driver version?
What is the difference between formal parameters and actual parameters?
what is dynamic SGA and static SGA
Is it possible to split the print reviewer into more than one region ?
Respected sir, Please send me technical questions related to oracle apps..
Why use resource manager in Oracle?
How to shutdown your 10g xe server from command line?
