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 to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to shutdown your 10g xe server from command line?
What is recycle bin in Oracle?
what is the difference between authorization and authentication?
How do I uninstall oracle 11g?
How to open a cursor variable?
What is difference between truncate and delete?
How to rebuild an index in oracle?
Give the various rollback segment states.
What is dictionary cache ?
How to define a cusotmer as a supplier in ORACLE R12
What is backup in Oracle?