Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
- 1 Answers
- 3775 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / oraclem
Index is a DB object that makes data retrieval faster.Index created on column and that column is called index key.
Types of index:
1)BTREE Index
2)BITMAP index
Purpose of creating INDEX: Oracle will take more time to locate the record,to improve the performance of the quesry we have to create the Index.
IF we do not mention the type of index,by default oracle will take BTREE as default Index.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is sql open source?
What is dialect in sql?
What is data type in sql?
Is id a reserved word in sql?
What is the difference between nested table and varray?
Can we use distinct and group by together?
What is sql catalog?
What are some predefined exceptions in pl/sql?
What is pl sql package?
What are the types of operators available in sql?
How do you update a table in sql?
What is the plv (pl/vision) package offers?
How to fetch alternate records from a table?
how do you control the max size of a heap table? : Sql dba
Can a table contain multiple foreign key’s?
