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 |
Can we call procedure inside function in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Please explain oracle data types with examples?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How do you handle duplicate records in a database?
Explain mutating triggers.
how to insert the image in table
What is Index Cluster ?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is the difference between RBBMS & DBMS?
Describe varray?
How to shutdown your 10g xe server from command line?