Re: [PERFORM] Index usage when bitwise operator is used

2007-09-16 Thread Valentine Gogichashvili
Hi, I could not find and normal solution for that issue. But I am using some workarounds for that issue. The solution, that I am using now is to create an index for every bit of your bitmap field. So something like CREATE INDEX idx_hobbybit_0_limited ON "versionA".user_fast_index USING btre

Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1

2007-09-16 Thread Kevin Grittner
>>> On Mon, Sep 10, 2007 at 2:25 PM, in message <[EMAIL PROTECTED]>, "Carlo Stonebanks" <[EMAIL PROTECTED]> wrote: > is the default setting of 4.0 realistic or could it be lower? Wow, such a simple, innocent question. As you may have inferred, it can't be answered in isolation. Make sure t

Re: [PERFORM] Index usage when bitwise operator is used

2007-09-16 Thread Kevin Grittner
>>> On Thu, Sep 13, 2007 at 7:30 AM, in message <[EMAIL PROTECTED]>, "W.Alphonse HAROUNY" <[EMAIL PROTECTED]> wrote: >and each binary value of [variableCategory] may only hold a single binary > '1'. > TBL1.CATEGORY & TBL2.CATEGORY <> 0 //-- where & is the AND bitwise > operator What abou