Re: Bitmap index performance

From: Lee Miller <DataAware_at_email.msn.com>
Date: Sat, 20 Mar 1999 19:42:00 -0500
Message-ID: <uiV5mOzc#GA.218@upnetnews02.moswest.msn.net>

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.
>
>
>

begin 666 fact.sql
M($-214%412!404),12 B4D%$05)?4%)/1"(N(D9!0U1?5$%"3$4B("@B1$E- M7U1%4E))5$]265])1"(@#0H_at_5D%20TA!4C(H-BD_at_3D]4($Y53$P_at_14Y!0DQ% M+" B04-#5%])1"(@5D%20TA!4C(H-BD_at_3D]4($Y53$P_at_14Y!0DQ%+" -"B B M4%)/1%])1"(@5D%20TA!4C(H-2D_at_3D]4($Y53$P_at_14Y!0DQ%+" B645!4E]- M3TY42"(@3E5-0D52*#8L(# I($Y/5" -"B!.54Q,($5.04),12P@(D-/34)/ M7T-/1$5?240B(%9!4D-(05(R*#0I($Y/5"!.54Q,($5.04),12P@(E!23T1? M4519(B -"B!.54U"15(H,3,L(#(I+" B24Y67T%-5"(@3E5-0D52*#$S+" R M*2P@(E!224]27U!23T1?4519(B!.54U"15(H,3,L( T*(#(I+" B04-#5%]0 M4D]$7TQ!4U1?4T],1%]914%27TU/3E1((B!.54U"15(H-BP@,"DL( T*(").

M051,7T)204Y$7U-!3$537T-!4T5?5D],7TE$(B!605)#2$%2,B_at_T*2P@#0H@
M(DY!5$Q?0E)!3D1?4T%,15-?0T%315]63TQ?1$530R(@5D%20TA!4C(H-3 I
M+" -"B B4D5'3E]"4D%.1%]304Q%4U]#05-%7U9/3%])1"(@5D%20TA!4C(H

M-"DL( T*(")214=.7T)204Y$7U-!3$537T-!4T5?5D],7T1%4T,B(%9!4D-( M05(R*#4P*2P@#0H@(DQ/0U]"4D%.1%]304Q%4U]#05-%7U9/3%])1"(@5D%2 M0TA!4C(H-"DL( T*("),3T-?0E)!3D1?4T%,15-?0T%315]63TQ?1$530R(@

M5D%20TA!4C(H-3 I+" B3$%35%]54$1!5$5?1$%412(@#0H_at_1$%412P@(DQ!
M4U1?55!$051%7U5315)?240B(%9!4D-(05(R*#$P*2D_at_4$-41E)%12 Q,"!0
M0U154T5$(#<U( T*($E.251204Y3(#$@34%85%)!3E,@,C4U(%!!4D%,3$5,

M("@@1$5'4D5%($1%1D%53%0_at_24Y35$%.0T53($1%1D%53%0I( T*($Y/3$]' M1TE.1R!35$]204=%*"!&4D5%3$E35%,@,2!&4D5%3$E35"!'4D]54%,@,2D@ M5$%"3$534$%#12 -"BX-"BX-"BX-"D-214%412!)3D1%6" B4D%$05)?4%)/ M1"(N(D9!0U0D04-#5%])1"1)6"(@3TX@(D9!0U1?5$%"3$4B( T**")$24U? M5$524DE43U)97TE$(B L(")!0T-47TE$(B L(")914%27TU/3E1((B I(%!# M5$92144@,3 @24Y)5%)!3E,@,B -"DU!6%1204Y3(#(U-2!35$]204=%("@@ M1E)%14Q)4U13(#$@1E)%14Q)4U0_at_1U)/55!3(#$@*2!.3TQ/1T=)3D<@4$%2 M04Q,14P@#0HN#0HN#0HN#0I#4D5!5$4_at_0DE434%0($E.1$58(")2041!4E]0 M4D]$(BXB1D%#5"104D]$7TE$)$)-4"(@3TX@(D9!0U1?5$%"3$4B( T**")$ M24U?5$524DE43U)97TE$(B L(")04D]$7TE$(B L(")914%27TU/3E1((B I M(%!#5$92144@,3 @24Y)5%)!3E,@,B -"DU!6%1204Y3(#(U-2!35$]204=% M("@@1E)%14Q)4U13(#$@1E)%14Q)4U0_at_1U)/55!3(#$@*2!.3TQ/1T=)3D<@ M4$%204Q,14P@#0HN#0HN#0HN#0I#4D5!5$4_at_0DE434%0($E.1$58(")2041! M4E]04D]$(BXB1D%#5"1914%27TU/3E1()$)-4"(@3TX@(D9!0U1?5$%"3$4B M( T**")$24U?5$524DE43U)97TE$(B L(")914%27TU/3E1((B I(%!#5$92 M144@,3 @24Y)5%)!3E,@,B!-05A44D%.4R R-34@#0I35$]204=%("@@1E)% M14Q)4U13(#$@1E)%14Q)4U0_at_1U)/55!3(#$@*2!.3TQ/1T=)3D<@4$%204Q, 514P@*"!$14=2144@#0HN#0HN#0HN
`
end Received on Sat Mar 20 1999 - 18:42:00 CST