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 produce numbers from 1 to 10 using dual table
Explain oracle’s server parameter file.
What is columnar storage what is the advantage?
Whether any commands are used for months calculation? If so, what are they?
How to connect to a remote server?
Explain database link?
what are the default admin accounts in Oracle 10g ?
How many types of segments in Oracle?
How to use "in out" parameter properly?
What is clusters ?
How to list all indexes in your schema?
What do you understand by a database object? Can you list a few of them?