Re: Deleting Large Numbers of Rows w/o Filling up my redo logs
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 22 Dec 2008 12:53:19 +0100
Message-ID: <494f7fb2$0$22686$426a74cc@news.free.fr>
Date: Mon, 22 Dec 2008 12:53:19 +0100
Message-ID: <494f7fb2$0$22686$426a74cc@news.free.fr>
"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.
Regards
Michel
Received on Mon Dec 22 2008 - 05:53:19 CST