Re: Hoe to avoid generate sysdistrib when create index

Jack Parker wrote: > The additional cost of collecting those statistics during index build is > minute - hence why the feature was added. I don't understand how you feel > that Sysdistrib is going to hurt your processing, can you give us the use > case? > > If you want to get rid of those entries you could always update statistics > low drop distributions; > > Did I read you correctly - you are at least doing "update statistics" - > correct? Could it be a BaaN site? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Obnoxio The Clown wrote: > Jack Parker wrote: >> The additional cost of collecting those statistics during index build is >> minute - hence why the feature was added. I don't understand how you >> feel >> that Sysdistrib is going to hurt your processing, can you give us the use >> case? >> >> If you want to get rid of those entries you could always update >> statistics >> low drop distributions; >> >> Did I read you correctly - you are at least doing "update statistics" - >> correct? > > Could it be a BaaN site? > ... with driver level 1, because level 2 uses stats... Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...