Interested to Buy Any Domain ? << Click Here >> for more details...
what is index?
- 4 Answers
- 7981 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 |
Explain the use of show option in imp command.
What is index-organized table in Oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Can you create a synonym without having a table?
How to update a table row with a record?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What does `(+)` do in a where clause?
How to store pictures on to the database?
How do we display rows from the table without duplicates?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
What is the difference between normal and corelated subqueries?
Explain table?
Oracle General 
