Re: serial and sequential scan

hajek@nspuh.cz wrote: > Thanks to all for your answers. > Art: I have dostats compiled (I tried to use myexport, but after > compiling, it coredumps on first index :-() I will try dostats, it Odd, what's core dumping, myschema or sqlunload? Myschema, I'd guess. Can you send me the exact myexport commandline, a stack trace from the core dump and a copy of the dbschema -ss output? I'd like to track down the problem and fix it. > works with no problem. > Does later "update statistics" clear "update statistiscs high" > optimizing hints? > Michal > Only if the 'DROP DISTRIBUTIONS' clause were to be included. Art S. Kagel