Re: About Oracle Bitmap Index...

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Wed, 14 May 2003 05:08:44 GMT
Message-ID: <3EC1CDF9.DB0E2600@telusplanet.net>

Stanley wrote:

> I create many Bitmap Indices on all attributes of a table which has
> about 100 attributes(A1~A100). I query data and use hint on it, when
> the Where clause including some of attributes of A1 to A50, it is good
> to work, but when the Where clause including some of attributes of A51
> to A100, it's performance will
> be very poor, why ???

Pretty please, give us a hint on the data distributions. How many unique values in each index, expressed both as a percent of total and absolute number? Received on Wed May 14 2003 - 00:08:44 CDT