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
Is sql injection illegal?
Can we create table in function?
What are the different sql commands?
How do I partition in sql?
What is hibernate and its relation to sql?
How do I edit a stored procedure?
What is a recursive join sql?
What are the 3 modes of parameter?
What is the difference between a primary key and a clustered index?
What is java sql connection?
What is an exception in PL/SQL? What are the two types of exceptions?
What is PL/SQL Records?
What are the benefits of stored procedures?
Explain polymorphism in pl/sql.
what is log shipping? : Sql dba