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 open a cursor variable?
How to set a transaction to be read only in oracle?
What are a cluster and non-cluster index?
How to write a query with an inner join in oracle?
Explain the difference between sap and oracle?
What are triggers in oracle?
How to pass parameters to procedures in oracle?
How do I connect to oracle?
What are group functions in oracle?
How do I find the database name in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Can a formula column referred to columns in higher group ?
How to assign data of the deleted row to variables?
What is the usage of analyze command in oracle?
Explain the use of grant option in imp command.
