Re: Wild query

On Mon, 19 Nov 2001 16:58:07 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

Yes I have been creating Bitmap indexes and am looking into this one.

>>SELECT STATEMENT Optimizer=FIRST_ROWS (Cost=69448 Card=1936427
>>Bytes=447314637)
>> SORT (GROUP BY) (Cost=69448 Card=1936427 Bytes=447314637)
>> HASH JOIN (Cost=37085 Card=1936427 Bytes=447314637)
>> TABLE ACCESS (FULL) OF DIM_DATE (Cost=34 Card=9135 Bytes=155295)
>> HASH JOIN (Cost=37047 Card=1936427 Bytes=414395378)
>> TABLE ACCESS (FULL) OF DIM_OFFICE (Cost=9 Card=8394
>>Bytes=176274)
>> HASH JOIN (Cost=37034 Card=1936427 Bytes=373730411)
>> TABLE ACCESS (FULL) OF DIM_DATE (Cost=34 Card=73414
>>Bytes=660726)
>> HASH JOIN (Cost=36981 Card=1936427 Bytes=356302568)
>> TABLE ACCESS (FULL) OF DIM_METER (Cost=1286 Card=2204807
>>Bytes=50710561)
>> HASH JOIN (Cost=34830 Card=1936427 Bytes=311764747)
>> TABLE ACCESS (FULL) OF DIM_PREMISE (Cost=5076
>>Card=2875649 Bytes=37383437)
>> HASH JOIN (Cost=28989 Card=1936427 Bytes=286591196)
>> TABLE ACCESS (FULL) OF DIM_ACCOUNT (Cost=17624
>>Card=5730437 Bytes=114608740)
>> HASH JOIN (Cost=9209 Card=2571184 Bytes=329111552)
>> TABLE ACCESS (FULL) OF DIM_CUSTOMER (Cost=2437
>>Card=2462171 Bytes=32008223)
>> HASH JOIN (Cost=5931 Card=3503875 Bytes=402945625)
>> TABLE ACCESS (FULL) OF DIM_MARKETER (Cost=1
>>Card=14 Bytes=308)
>> HASH JOIN (Cost=5929 Card=5005535 Bytes=465514755)
>> TABLE ACCESS (FULL) OF DIM_METER_ACTIVITY
>>(Cost=1 Card=12 Bytes=372)
>> HASH JOIN (Cost=5927 Card=9593943
>>Bytes=594824466)
>> TABLE ACCESS (FULL) OF DIM_TARIFF_SCHEDULE
>>(Cost=1 Card=12 Bytes=108)
>> HASH JOIN (Cost=5925 Card=15989905
>>Bytes=847464965)
>> TABLE ACCESS (FULL) OF DIM_DELIVERY_GROUP
>>(Cost=1 Card=8 Bytes=56)
>> TABLE ACCESS (FULL) OF FACT_METER_ACTIVITY
>>(Cost=5923 Card=21986120 Bytes=1011361520)
>
> Received on Tue Nov 20 2001 - 04:05:34 CST