OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Bitmap Index (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Bitmap Index [message #327268]

Sun, 15 June 2008 22:18

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.

Report message to a moderator

Re: Bitmap Index [message #327273 is a reply to message #327268]

Sun, 15 June 2008 22:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Bitmap index is for high transaction with low cardinality or low transaction with low cardinality
YES

Report message to a moderator

Re: Bitmap Index [message #327274 is a reply to message #327268]

Sun, 15 June 2008 22:36

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

Report message to a moderator

Re: Bitmap Index [message #327280 is a reply to message #327268]

Sun, 15 June 2008 23:21

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 05:53:22 CST 2024