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
- 3709 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
Can you have more than one key in a database?
Explain what is a field in a database and record in a database?
Why do you partition data?
Why we use join in sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What are keys in sql?
Do we need to create index on primary key?
What are different types of keys?
What is use of term?
what is a relationship and what are they? : Sql dba
Explain the insert into statements in sql?
Is pl sql better than sql?
What information is needed to connect sql*plus an oracle server?
how to get a list of all tables in a database? : Sql dba
What is nosql example?
