It seems to me that there's no way of Unclustering an index once it's
clustered?  ie.  You cannot turn off ALL clustering on a table?

Chris


Fri, 23 May 2003 10:28:59 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Un-clustering an index
On Fri, May 23, 2003 at 10:28:59AM +0800, Christopher Kings-Lynne wrote:
> It seems to me that there's no way of Unclustering an index once it's
> clustered?  ie.  You cannot turn off ALL clustering on a table?

Err... no.  Why would you want that?  If you don't want it clustered,
just don't run CLUSTER on it.

Oh, but it'll still get clustered by CLUSTER ALL.  Maybe there should be
a way to set it not to cluster (ALTER TABLE ... NO CLUSTER?)

There's still the catalog modification path (set indisclustered=false),
of course.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"No hay hombre que no aspire a la plenitud, es decir,
la suma de experiencias de que un hombre es capaz"


Fri, 23 May 2003 10:09:19 -0400
Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>
Re: Un-clustering an index