Interested to Buy Any Domain ? << Click Here >> for more details...
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
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the recommended interval at which to run statspack snapshots, and why?
What is the best way to do multi-row insert in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How many categories of data types?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Define oracle database
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to bring a tablespace offline?
What is connection pooling in oracle?
What is proxy method?
Differentiate between function and procedure in oracle.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Give the constructs of a package, function or a procedure.
Explain oracle’s system global area (sga).
