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
- 3705 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 |
What is the difference between having and a where in sql?
What is pl sql in oracle?
What is replication id?
How do I audit the sql sent to the server?
Why is %isopen always false for an implicit cursor?
What is compound trigger?
what is the command used to fetch first 5 characters of the string? : Sql dba
How to prepare for oracle pl sql certification?
What is memory optimized?
How do I find duplicates in sql?
What are the three forms of normalization?
Is trigger a stored procedure?
-
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)
