Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
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
How to sort the rows in sql.
Explian rowid, rownum? What are the psoducolumns we have?
How do you use join?
Define join and name different types of joins?
What does closing a cursor do?
What are the usages of sql?
What is the basic structure of an sql?
What are packages in pl sql and also explain its advantages?
How sql query is executed?
How to write pl sql program in mysql command prompt?
What is trigger explain it?
How can you get sql*loader to commit only at the end of the load file? : aql loader
Why trigger is used in sql?
Why schema is used in sql?
What is meant by temporal data?