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 |
Explain about achiever in sql?
Explain about your project and its relation to the current job position you are applying to?
What are different Oracle database objects?
How to write date and time interval literals in oracle?
How to use fetch statement in a loop?
What is java oracle used for?
is database gud carrier option??
Why is oracle so popular?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
What is oracle update statement with inner join ?
How to insert multiple rows with one insert statement in oracle?
What are the factors causing the reparsing of SQL statements in SGA?