Re: Update Statistics

Posted in 1997

David Williams — Sat, 22 Mar 1997 23:32:56 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <3333C79F.51D1C44B@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes >> As per the book, the estimate should be 500 > >the book makes a difference between "indexed-cols" and "any-cols". >So what's the meaning of "any-cols" ? > Any col which does not have indicies on it that can be used..i.e. is not an indexed-col. >> (i.e selectivity 1/10 for cols >> which are not the first in an index). However, the book (Performance Guide >> Ch4) also says the selectivity logic mentioned is 'not exhaustive'. >> It seems to be treated ass an indexed column for which update statistics >> low has not been run - -- David Williams