Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192552 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / gouranga mohapatra
There are several types of indexes available in Oracle all
designed for different circumstances:
•b*tree indexes - the most common type (especially in OLTP
environments) and the default type
•b*tree cluster indexes - for clusters
•hash cluster indexes - for hash clusters
•reverse key indexes - useful in Oracle Real Application
Cluster (RAC) applications
•bitmap indexes - common in datawarehouse applications
•partitioned indexes - also useful for datawarehouse
applications
•function-based indexes
•index organised tables
•domain indexes
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why do we use bulk collect in oracle?
What would you do with an in-doubt distributed transaction?
How to assign query results to variables?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
what is insert all statement in sql
What is a subquery?
How to create a temporary table in oracle?
material view and view disadvantages?
How do you bind variables in oracle?
How to get a create statement for an existing table?
How to store pictures on to the database?
what is dynamic SGA and static SGA
How to write numeric literals in oracle?
Can you assign multiple query result rows to a variable?
What is an oracle cursor variable?
