Re: Question about CLUSTER

On Feb 11, 2008 2:03 PM, salman <salmanb@quietcaresystems.com> wrote:
> Hello,
>
> I'm planning to cluster a few large tables in our database but I'm
> unable to find any recommendations/documentation on best practices --
> Mainly, whether it's better to use an index which has a higher idx_scan
> value, a higher idx_tup_read value, or the higest idx_tup_fetch value.
>
> I'm assuming that idx_tup_read would probably be the best choice, but
> want to get other opinions before proceeding.

If you've got two indexes that are both being hit a lot, it might be
worth looking into their correlation, and if they get used a lot
together, look at creating an index on both.

But I'd guess that idx_tup_read would be a good bet.