Home » SQL & PL/SQL » SQL & PL/SQL » Bitmap Index (oracle 10g)
Bitmap Index [message #327268] Sun, 15 June 2008 22:18 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,
Am having little confusion about bitmap index.Kindly clarify it.Bitmap index is for high transaction with low cardinality or low transaction with low cardinality.
Re: Bitmap Index [message #327273 is a reply to message #327268] Sun, 15 June 2008 22:31 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
>Bitmap index is for high transaction with low cardinality or low transaction with low cardinality
YES
Re: Bitmap Index [message #327274 is a reply to message #327268] Sun, 15 June 2008 22:36 Go to previous messageGo to next message
ttparavindh
Messages: 22
Registered: December 2006
Location: Bangalore,India
Junior Member

this may help you

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/data_acc.htm#PFGRF004

regards,
Aravindh
Re: Bitmap Index [message #327280 is a reply to message #327268] Sun, 15 June 2008 23:21 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 1 Introduction to the Oracle Database
Section Bitmap Indexes in Data Warehousing

Chapter 5 Schema Objects
Section Overview of Indexes
Paragraph Bitmap Indexes

All these kinds of questions are answer in Database Concepts, just have a look at its TOC.

Regards
Michel
Previous Topic: getting ORA-01438 error (field presion) on update from fields of the same presision
Next Topic: Dictionary table to see the operation of a procedure
Goto Forum:
  


Current Time: Tue Dec 06 00:01:01 CST 2016

Total time taken to generate the page: 0.11796 seconds