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 |
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the ways tablespaces can be managed and how do they differ?
Explain 1st, 2nd, 3rd normalization form of data base
Can a property clause itself be based on a property clause ?
How much memory your 10g xe server is using?
How many categories of data types in oracle?
Which is better Oracle or MS SQL? Why?
What is the order of defining local variables and sub procedures/functions?
Find all employees in Dept “Marketing”.
how to find the second highest salary in a given table????
How to create an initialization parameter file?
What is a Temporary Segment ?