Re: Optimiser choice of index

Update statistics high on 1st column in each index, low on other indexedcolumns is what's recommneded by Informix, what else should I run? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "scottishpoet" <dryburghj@yahoo.com> >Reply-To: "scottishpoet" <dryburghj@yahoo.com> >To: informix-list@iiug.org >Subject: Re: Optimiser choice of index >Date: 23 Sep 2005 03:45:06 -0700 > >1/ Bug in the optimiser > >2/ The Update Statistics strategy you used did not obtain appropriate >information to provide the optimser with enough detail to choose the >right index sending to informix-list