Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
- 1 Answers
- 3272 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
How to display Row Number with Records in Oracle SQL Plus?
What is spool?
Can you have more than one key in a database?
What is nosql example?
what tools available for managing mysql server? : Sql dba
What is scope of pl sql developer in future?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is a sql*loader control file?
What is the most important ddl statements in sql are?
how to load data files into tables with 'mysqlimport'? : Sql dba
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What programs use sql?
Can we write dml inside a function in sql server?
what are the different functions in sorting an array? : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
