On Oct 6, 2006, at 11:12 AM, John D. Burger wrote:
Richard Huxton wrote:
Should I always cluster the tables? That is, even if no column
jumps out as being involved in most queries, should I pick a
likely one and cluster on it?
Well you cluster on an index, and if you don't think the ind
Richard Huxton wrote:
Should I always cluster the tables? That is, even if no column
jumps out as being involved in most queries, should I pick a
likely one and cluster on it?
Well you cluster on an index, and if you don't think the index is
useful, I'd drop it. If you have an index, clu
John D. Burger wrote:
I have a good-size DB (some tables approaching 100M rows), with
essentially static data.
Should I always cluster the tables? That is, even if no column jumps
out as being involved in most queries, should I pick a likely one and
cluster on it? (Of course, this assumes t
