Re: partions in Oracle 8

I used the Partition views in 7.3 and had some good experiences with them. Oracle8 looks even better because it is now a truly partitioned table. Just make sure that you choose your partitioning key correctly, keep the tables analyzed, always delete your statistics before you compute/estimate them, partition your indexes also, and one last thing - alot of places use partitioning for data that is not updated alot. Force batch updates to the table instead of online. Build unique indexes before the updates, and then drop them afterwards (if they are long complex indexes). Analyze your indexes separately. Build them in parallel unrecoverable where you can. Eat your vegetables. Spread all of the tables out over several datafiles if possible (depending upon the size). LIve long and prosper.

I offer all of this to you and I hope that some of it helps.

Alan

John Bishop wrote in message <35048798.FFC70460_at_atl.mediaone.net>...
>I have a conifguration that really lends itself to either using either a
>series of unions with multiple tables, or implimenting partitions in
>Oracle 8.
>
>Has anyone had any good or bad experiences with partitions?
>
>The partitioning gig looks like a great idea - we'll be storing data on
>a monthly basis and the sum of the partions will be the year to date
>table. In other words, I'm looking at creating a partition of 1/1/98,
>2/1/98, 3/1/98... data
>
>OR
>
>I'm creating a table that pretty much has =< N-2 months worth of data
>with month N-1 and month N seperate. (I'm seperating them because they
>will be the most recent, and as the most recent tables N-1 and N tables
>will see the most activity.) So a union would be of N-2(archive) and
>N-1(last month) and N (this month). Moving the data around will be a
>month end process.
>
>So what are your suggestions. The partions look easier to manager, but
>the view lends itself to simplicty (other than the moving around) and
>it's proven technology.
>
>Good or bad experiences are appreciated.
>
>JB
>
Received on Tue Mar 10 1998 - 00:00:00 CST