Re: Partitioning -- good? cost?

From: Steve Phelan <stevep_at_XXnospamXX.toneline.demon.co.uk>
Date: Fri, 24 Apr 1998 17:08:22 +0100
Message-ID: <893434071.13487.0.nnrp-01.c2de712e@news.demon.co.uk>

John Gassman wrote in message <353feb0e.0_at_athena.netset.com>...
>I couldn't live without them! I run 8.0.3 on Windows NT and I have a huge
>table (> 40 GB) that I need to contain 'rolling' data. Previously I had to
>delete out old records (this took FOREVER) or periodically truncate the
>table and start over. With partitions, I can add a new partition for a new
>day and drop the oldest day's partition - takes about a minute. Plus,
>paritioning in Oracle8 is automatic - you don't have to figure out which
>partition the data belongs in. Paritioning also helps speed up access if
>partitions are divided by the same criteria as your queries - eg: date -
>Oracle knows it only has to look in certain partitions and can skip the
>rest.

Agreed.

>
>As far as I know, partitioning is included with Oracle8 at no additional
>cost.

Disagree. Partitioning and Objects are both separate costed items to Oracle 8.

Steve Phelan. Received on Fri Apr 24 1998 - 11:08:22 CDT