Re: Update Statistics Plan for IDS 7.31

Posted in 1999

Obnoxio The Clown — Tue, 19 Oct 1999 20:43:44 BST — source: Informix-list mailing list archive (1991-1998)

From: "Carlson@WHSmith" <carlson1@bellsouth.net> > >Or should that be columns a, c, and d??? ART?!?!? :-) >Obnoxio The Clown wrote: > > > > From: "Adam Bradley" <Adam.Bradley@ahmg.com.au> > > > > > >2. Run the "UPDATE STATISTICS HIGH" command with "DISTRIBUTIONS ONLY" >for > > >all columns that head an index.This accuracy will give the optimizer >the > > >best data about an index's selectivity. > > > > AFAIK: > > If you have two indexes > > > > index1 on table (a, b, c) > > index2 on table (a, b, d) > > > > You should use USHDO on columns a and b. > > > > ______________________________________________________ > > Get Your Private, Free Email at http://www.hotmail.com ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com