I would only like this as a feature if the optimizer can really take
advantage of this. Clustering on every insert or update just for the
fun of it won't really give us anything but more expensive writes.
I kinda figured if SQL Server and Oracle have it, they probably take
full advantage of it for reads..
Mike
Simon Riggs wrote:
On Tue, 2009-03-17 at 09:16 -0400, Alvaro Herrera wrote:
I'm quite sure SQL Server doesn't work this way and I'm not sure
about
Oracle. Can someone enlighten me on the exact benefit of this?
Thanks!!
Yeah, they use a completely different definition of "clustered index"
from ours.
Hopefully we regard it as a missing feature rather than as a separate
definition. We could cluster the index, we just don't, yet.
