Answer Posted / rad
An index is an oracle object that stores ROWID (pointer)
and columns(s) data on a source table. Two main types are
B-tree and Bitmap. An index is crucial as it can preempt
unnessessary full table scans on the source table if the
queried data is included the indexed column(s). B-tree
primarily useful in OLTP and Bitmap is DSS (generally..)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a snapshot in oracle database?
What privilege is needed for a user to connect to oracle server?
How to Truncate Table in Oracle
What is oracle datasource?
How do we represent comments in oracle?
What is an Oracle index?
How to view the tablespaces in the current database?
How to insert a record into a table?
What is an oracle table?
How to use like conditions in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to assign data of the deleted row to variables?
Explain the use of constraints option in exp command.
How do we get field detail of a table?
How to write a query with a right outer join in oracle?