There are three articles I have written
about bitmap indexes on www.dbazine.com
that might help.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
____Denmark__May 21-23rd
____Sweden___June
____Finland__September
____Norway___September
Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May x 2
____Estonia___June 4th - 6th
____Australia_June 18th - 20th (Perth)
____Australia_June 23rd - 25th (t.b.a)
____USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
"Stanley" <chiujen.lin_at_msa.hinet.net> wrote in message
news:ebf3513d.0305121959.3bc5d527_at_posting.google.com...
> 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 ???
>
Received on Tue May 13 2003 - 00:45:35 CDT
