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
What happens to the data files if a tablespace is dropped?
What is connection pool in oracle?
what is insert all statement in sql
defination of bitmap index
How different is ms access and oracle?
What is oracle analytical function?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Explain an exception?
How can Oracle users be audited?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the differences between primary key and unique key?
What are the various types of snapshots ?
What are the different oracle database objects?
Is there an oracle sql query that aggregates multiple rows into one row?
What are a cluster and non-cluster index?
