Re: Bitmap Index Problem

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 2000/09/20
Message-ID: <8qbk10$mnt$1@garnet.tc.umn.edu>#1/1

On Oracle 7.3.4 the bitmap index needed histograms - analyze the column that the index is on, for example, a column named "status". Read the SQL Reference manual for exact syntax.

It did not use the bitmap index when
the where clause contained an "status IN ('X','Y')". And it did not use the bitmap index with a where clause containing a "status = 'X' OR status = 'Y'"

It _DID_ use the bitmap index with a "UNION" of two simple selects.

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.tc.umn.edu/~hause011


---------------------------------------------------------

Received on Wed Sep 20 2000 - 00:00:00 CDT