Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bitmap index performance
I'm assuming you have put proper storage clauses since they were
not included in the script.
Are you running parallel query and/or MTS?
Lee Miller wrote in message ...
>As requested:
>
>I've attached the main table of this query....table currently has over 40
>million rows.
>Jonathan Lewis wrote in message
><921952846.4405.0.nnrp-13.9e984b29_at_news.demon.co.uk>...
>>I meant the columns, not the physical storage.
>>
>>--
>>
>>Jonathan Lewis
>>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>>
>>Lee Miller wrote in message ...
>>>FYI,
>>>
>>>I just changed the initora parameter bitmap_merge_area_size from 1mb to
>6mb
>>>and one of my benchmark queries went from 4 minutes to 30 seconds.
>>>
>>>The index definitions are extemely large. I am using partition tables.
>>>These are local indexes. Right now I have 30 partitions for this table.
>>
>>
>>
>
>
>
Received on Sun Mar 21 1999 - 07:04:58 CST