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"