Re: When should one rebuild an index?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 14 Jan 2009 14:40:31 +0000 (UTC)
Message-ID: <gkktgv$e5p$2_at_solani.org>
On Wed, 14 Jan 2009 03:37:58 -0800, raja wrote:
Date: Wed, 14 Jan 2009 14:40:31 +0000 (UTC)
Message-ID: <gkktgv$e5p$2_at_solani.org>
On Wed, 14 Jan 2009 03:37:58 -0800, raja wrote:
> a. first i want to know, how to check whether there is data in the max
> partition ?
You can try with "alter table truncate <partition name>". If anybody starts screaming, there was some data in the partition.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Wed Jan 14 2009 - 08:40:31 CST