Interested to Buy Any Domain ? << Click Here >> for more details...
what is index?
- 4 Answers
- 8141 Views
- I also Faced
- E-Mail Answers
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 |
What is the relation of a user account and a schema in oracle?
How to use existing values in update statements using oracle?
List out the components of logical database structure of oracle database.
What is a Temporary Segment ?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What privilege is needed for a user to connect to oracle server?
How to end the current transaction in oracle?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
Can a property clause itself be based on a property clause ?
How do I call oracle stored procedures that take no parameters?
Where is the export dump file located?
How to define a variable to match a table column data type?
Oracle General 
