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
- 3778 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 |
Is trigger a stored procedure?
Define concurrency control. : Transact sql
What does count (*) mean?
How to fetch alternate records from a table?
What does fetching a cursor do?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
What is integrity constraints?
What is the differnce between view and materialized view
Is primary key an index?
what is organisational index?
How does sql store data?
-
Oracle (3253) - 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)
