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
- 3648 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer / 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 |
How many rows will return from dual table?
Which normal form is best?
What are the uses of merge?
How do I filter in sql profiler?
what are the different index configurations a table can have? : Sql dba
What schema means?
how to create temparary sequence
Is natural join and inner join same?
how to get a list of columns in an existing table? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
What is schema in sql example?
What does inner join mean?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
