On Feb 11, 2008 2:03 PM, salman <salmanb@xxxxxxxxxxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
