Re: Dynamic Optimizer problems??

Posted in 1996

Vic Goldberg — Fri, 15 Nov 1996 10:11:35 -0500 — source: Informix-list mailing list archive (1991-1998)

Ronald E. White wrote: > > ...seem to be having problems with the > dynamic optimizer going to the BIG table to do its first search, then > going to the little table last. Have you tried doing an update statistics medium on both the big and little tables? It sounds like the optimizer is relying on out of date statistics..... -- Victor Goldberg (607) 254-7441 Cornell Theory Center (607) 254-8888 (fax) 520 Rhodes Hall vic@tc.cornell.edu Ithaca, NY 14850