Interested to Buy Any Domain ? << Click Here >> for more details...
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 do I spool in oracle?
How to load data through external tables?
What is using clause and give example?
How to select an oracle system id (sid)?
What is meant by recursive hints in oracle?
What are the numeric comparison operations?
What is redo log?
How to revoke create session privilege from a user in oracle?
What are the restrictions in a oracle read only transaction?
What is a nvl function? How can it be used?
What suggestions do you have to reduce the network traffic?
What would you do with an in-doubt distributed transaction?
Explain index?
What is a table index?
Explain the use of indexes option in exp command.
