Re: Deleting Large Numbers of Rows w/o Filling up my redo logs
Date: Mon, 22 Dec 2008 14:30:15 +0000 (UTC)
On Mon, 22 Dec 2008 12:53:19 +0100, Michel Cadot wrote:
> "Mladen Gogala" <gogala.mladen_at_gmail.com> a écrit dans le message de
> news: ginspr$ll0$2_at_solani.org... | On Sat, 20 Dec 2008 17:37:55 +0100,
> Michel Cadot wrote: |
> | > Partition your log table per week and drop oldest partition each
> week. |
> | What should he do with the global indexes, like PK? Keep rebuilding? |
> Shut down the application while the PK is being rebuilt? |
> | --
> | Mladen Gogala
> | http://mgogala.freehostia.com
> Maybe he can add the date column to the PK and make it local. Maybe.
I am not sure that a PK constraint can be enforced by a local index.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Mon Dec 22 2008 - 08:30:15 CST