Re: BITMAP INDEXES...

<p>Bitmapped indexes are good for weakly constrained queries. Else B+tree indexes are better any day. <p>Also I guess
bitmappedindexes work better when there is an OR predicate on different columns in a query. <p> <b><i>Bruce Momjian
</i></b>wrote:<blockquote style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><br />See the
emailabout bitmapped indexes linked to from the TODO list item<br />on bitmaps. Bitmap indexes allow arbitrary indexes
tobe combined into<br />a single index. Btree indexes can not be combined.<br /><br
/>---------------------------------------------------------------------------<br/><br />Rajesh Kumar Mallah. wrote:<br
/>>Hi,<br />> <br />> I have learnt from certain texts that bitmap indexes are very useful for<br />> large
DSS(decesion support systems).<br />> <br />> bitmap indexes are currently not available in postgresql.<br />>
<br/>> My question is in what way is a normal btree index in pgsql<br />> inferior to bitmap indexes (found in
oraclefor example).<br />> <br />> is it just in terms of space requirements for performance too?<br />> <br
/>><br />> regds<br />> mallah.<br />> <br />> <br />> -- <br />> Rajesh Kumar Mallah,<br />>
ProjectManager (Development)<br />> Infocom Network Limited, New Delhi<br />> phone: +91(11)6152172 (221) (L)
,9811255597(M)<br />> <br />> Visit http://www.trade-india.com ,<br />> India's Leading B2B eMarketplace.<br
/>><br />> <br />> <br />> ---------------------------(end of broadcast)---------------------------<br
/>>TIP 2: you can get off all lists at once with the unregister command<br />> (send "unregister
YourEmailAddressHere"to majordomo@postgresql.org)<br />> <br /><br />-- <br />Bruce Momjian |
http://candle.pha.pa.us<br/>pgman@candle.pha.pa.us | (610) 359-1001<br />+ If your life is a hard drive, | 13 Roberts
Road<br/>+ Christ can be your backup. | Newtown Square, Pennsylvania 19073<br /><br />---------------------------(end
ofbroadcast)---------------------------<br />TIP 4: Don't 'kill -9' the postmaster</blockquote><p><br /><hr size="1"
/><b>DoYou Yahoo!?</b><br /><a href="http://rd.yahoo.com/careers/mailsig/new/*http://www.hotjobs.com">HotJobs, a Yahoo!
service</a>- Search Thousands of New Jobs