what is index?
Answers were Sorted based on User's Feedback
Answer / guest
Index is used for fast retrieving of data from table.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / mohan
With the help of index we can access the data quickly from
the table....
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
How do I uninstall oracle 11g?
How to define a data field as not null?
How does oracle handle read consistency?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
What is the difference between sharding and replication?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How many memory layers are in the oracle shared pool?
How to handle a single quote in oracle sql?
difference between imlicit cursor and explicit cursor ?
How to write text literals in oracle?
What is a Synonym ?
What happens to the indexes if a table is recovered?