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
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to pass a parameter to a cursor in oracle?
How to connect ms access to oracle servers?
How do I start tns listener?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to use subqueries in the from clause in oracle?
What is a static data dictionary in oracle?
How to change program global area (pga) in oracle?
How to export your connection information to a file?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is an oracle tablespace?
What is the quickest way to fetch the data from a table?
How do we create privileges in oracle?
How to get a list of all user accounts in the database?
How do I find my oracle client driver version?