> Clustering is really static i.e. it's done and after it any inserts/updates start spoiling the table again.
> So I guess the answer is no. Maybe you can create a procedure that does
> CLUSTER and then recreates the indeces and whatever else you lose in the
> process.
What a pity,
I used to do some benchmarks and little studies using explain
and cluster had huge effect on efficency with data I used.
I thought it works like table partitions in oracle only within one data
location, pity.
Thanx.
--
Dariusz Pietrzak
Certified Nobody