Re: Problem with Informix 7.3 I need a good Idea very soon

Posted in 1998

Thomas J. Girsch — Wed, 25 Nov 1998 12:56:21 -0500 — source: Informix-list mailing list archive (1991-1998)

Guten Tag, Herr Brust. What is OPTCOMPIND set to? If it's set to 1 or 2, it is much more likely to do a full table scan than if it were set to 0. If it is not zero, try setting to zero. Bundesarchiv wrote in message <73ggjp$eeg$1@goof.de.uu.net>... > >E posibile >to mark a table (a priori) as "AVOID_FULL"(scan) ?? > >or (i.e. with UPDATE STATS) "near fullscan disabled" ?? > >(in Informix 7.3) > > >I need a good Idea very soon > >Ernst-Ludwig Brust > >