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
How to compare dates in oracle sql?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is meant by raw datatype?
Explain the difference between sap and oracle?
What are the different types of database objects?
How to define a variable of a specific record type?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What language does oracle use?
What are the roles of dba?
What is recovery manager(rman) backup in Oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How to return top 5 rows in oracle?
How to write date and time literals in oracle?
How to define default values for formal parameters?
How to use subqueries with the in operator using oracle?
