Re: Update Statistics Plan for IDS 7.31

Posted in 1999

Carlson@WHSmith — Tue, 19 Oct 1999 09:47:09 -0400 — source: Informix-list mailing list archive (1991-1998)

Or should that be columns a, c, and d??? John Carlson Informix DBA WHSmith USA 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