Indexes in oracle ?

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


Please Help Members By Posting Answers For Below Questions

State some uses of redo log files?

768


How to create a table in a specific tablespace?

739


What are nested tables?

860


How to retrieve the count of updated rows?

788


Why do you create or replace procedures rather that drop and recreate.

753


Can we write dml statement in function in oracle?

828


Which is better Oracle or MS SQL? Why?

4428


Can we convert a date to char in oracle and if so, what would be the syntax?

778


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 ?

2238


how can we store any pdf file in oracle

1863


what is meant by magic query

1955


What happens to the current transaction if a ddl statement is executed?

773


How to pass parameters to procedures?

758


What's dateware house and what's clustor with practicle example

1924


Can you assign multiple query result rows to a variable?

754