Re: Update Statistics Plan for IDS 7.31

On Wed, 20 Oct 1999 03:42:10 GMT, dwilson@gtemail.net (Douglas Wilson) wrote: >On Tue, 19 Oct 1999 08:42:48 BST, "Obnoxio The Clown" <obnoxio@hotmail.com> >wrote: >>If you have two indexes >> >>index1 on table (a, b, c) >>index2 on table (a, b, d) >If these are the only indexes on the table, > >update medium on b and all other columns distributions only, or just update medium distributions only on the whole table, or the whole database for that matter since 'they say' that the extra time to do more columns is not significant. I've never tried to figure out how non-significant the time really is, but in my utility, I specify column names just because I wanted to, and in Art's utility, it just does the whole table. >update high on a distributions only, >update high on c distributions only, #not neccessary, but suggested >update high on d distributions only, # same comment as above # because the above two columns are the first unique columns # in multicolumn indices. >update low on (a,b,c) >update low on (a,b,d) > >which is what either his or my update stats utility will do, >both available at http://www.iiug.org > > >Cheers, >Douglas Wilson