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 connect to a local oracle 10g xe server?
What is Virtual Private Database in Oracle?
What do you understand by database schema and what does it hold?
Is primary key indexed by default in oracle?
What is the difference between pre-select and pre-query?
What language does oracle use?
How to view the tablespaces in the current database?
How to add another datafile to a tablespace?
What is a lookup table in oracle?
What is a package ? What are the advantages of package ?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What are the uses of synonyms?
What is a connect identifier?
What are the advantages of oracle 12c?
Will you be able to store pictures in the database?
