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
Which are the five query types available in oracle?
Explain database link?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to concatenate two text values in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to define an anonymous block?
What is the difference between a primary key & a unique key?
What is a oracle database?
Explain a data segment?
Explain compound trigger in oracle?
What is index-organized table in Oracle?
How to delete a column in an existing table?
what is the difference between restoring and recovering?
Difference between inner join vs where ?
What are the different pseudo commands? Explain in general?
