Re: When should one rebuild an index?

From: Mladen Gogala <>
Date: Wed, 14 Jan 2009 14:40:31 +0000 (UTC)
Message-ID: <gkktgv$e5p$>

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
Received on Wed Jan 14 2009 - 08:40:31 CST

Original text of this message