Answer Posted / radha
Indexes in Oracle are:
(create <type of index> index <indexname> on <tablename>
(<colname>)
1. B-Tree (regular indexing algorithm )
2. Bitmap (for low cardinality fields.
By default oracle creates bitmap Index)
3. Partitioned indexes (for manageability
and to distribute I/O evenly)
4. Function based indexes (when you want
to index a function based calculation itself)
5. IOTs (Index organised tables - Table and
Index combined into one)
6. Domain Indexes (using user defined index types)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to rename an existing table?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is background process in Oracle?
How to put more than 1000 values into an oracle in clause?
What is object data modeling?
Why packages are used in oracle?
List the types of joins used in writing subqueries?
How to get a create statement for an existing table?
How to install oracle database 10g xe?
How do you bind variables in oracle?
How to delete multiple rows from a table in oracle?
Respected sir, Please send me technical questions related to oracle apps..
What are the major difference between truncate and delete?
How to increment dates by 1 in oracle?
How to add a new column to an existing table in oracle?
