Re: Update Statistics

Posted in 1997

"Billy Wheeler" — 19 Mar 1997 01:04:13 -0500 — source: Informix-list mailing list archive (1991-1998)

On 18 Mar 97 at 20:16, Stefan Weideneder wrote: [SNIP] > I believe, and that's my own opinion, the optimizer assumes that every > index is very selective, when you directly search for all indexed columns. [SNIP] > UPDATE STATISTICS (LOW) FOR TABLE t1; [SNIP] > Any comments ??? Well, yes: OnLine >=6 has a different structure for sysindexes, and I think the selectivity of the index is only updated if you UPDATE STATISTICS >= MEDIUM. I could be wrong, mind you! :) -- Ciao, Billy "...nod's as good as a wink to a blind bat..."