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
State some uses of redo log files?
How to create a table in a specific tablespace?
What are nested tables?
How to retrieve the count of updated rows?
Why do you create or replace procedures rather that drop and recreate.
Can we write dml statement in function in oracle?
Which is better Oracle or MS SQL? Why?
Can we convert a date to char in oracle and if so, what would be the syntax?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
how can we store any pdf file in oracle
what is meant by magic query
What happens to the current transaction if a ddl statement is executed?
How to pass parameters to procedures?
What's dateware house and what's clustor with practicle example
Can you assign multiple query result rows to a variable?