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 are the attributes that are found in a cursor?
What are the parameters that we can pass through a stored procedure?
What is a oracle database?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
how do u setup a replication site?
How to export several tables together?
How to select all columns of all rows from a table in oracle?
what is the difference between functional dependecy and multilevel dependency?
What are the various types of snapshots ?
What is the use of aggregate functions in oracle?
State some uses of redo log files?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to change program global area (pga) in oracle?
Is there a function to split a string in plsql?
Can you tell me how to add new column in existing views?how?How is possible?