No luck. I tried everything you guys suggested, but didn't get anywhere.
Perhaps it's a bug in NT's port.
nelsona_at_my-dejanews.com wrote in message
<6reseo$nf7$1_at_nnrp1.dejanews.com>...
>In article <mHvC1.2056$ds2.687553_at_news.tpnet.pl>,
> "Dariusz Trocha" <trocha_at_friko5.onet.pl> wrote:
>> I'm afraid, optimizer won't take a bitmap index plan unless:
>> - it can use two or more bitmap indexes simultaneously or
>> - you put a hint forcing him to do this
>>
>> Darek
>>
>>
>What a crock!!!
>
>The optimizer WILL use a single bitmap index. I've witnessed it numerous
>times, and it works quite nicely.
>
>Just make sure that your table has been analyzed after you have built your
>indexes using
>
>analyze table ... compute statistics for table for all indexed columns
>
>and analyze your indexes
>
>analyze index .... compute statistics.
>
>
>Keep in mind however, that if you have a bitmap index on a column that is
>frequently updated, you will pay a price in additional overhead to maintain
>the index.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Aug 19 1998 - 19:27:44 CDT
