RE: OPTCOMPIND

Posted in 2005

Dirk Moolman — Wed, 17 Aug 2005 14:16:50 +0200 — source: Usenet: comp.databases.informix

-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Superboer Sent: 17 August 2005 11:46 AM To: informix-list@iiug.org Subject: Re: OPTCOMPIND >oltp use optcompind=0!!! > >if small table with indexes and current stats you will get index >lookups. if set to 2 the optimizer may choose seq scans causing locking >problems etc. >and when your table grows and you do not run update stats it still will >seq scan causing perf problems. > >so 0 for otlp > >Superboer My system is OLTP, and 0 just brings my system to a grinding halt sending to informix-list