Re: Problem with nightly batch job against a 1.5Gig table. Also BITMAP prob

>>>>> "NC" == NetComrade <netcomradeNOSPAM_at_earthlink.net> writes:

    NC> select count(*) from BIG_TABLE where player_id=12345 and     NC> drop_v_add=0 and date <= certain_date;

If the 'big' table is a rolling history table, you might want to consider partitioning by date.

Oracle 7.3.4 achieves this using partition views while 8.x supports true table partitioning.

Partition elimination might give you big gains and some future proofing if the 'big' table is going to get 'very_big' in N years time. Received on Fri Jul 23 1999 - 10:18:18 CDT