Re: index problem

Posted in 2000

Obnoxio The Clown — Fri, 09 Jun 2000 11:38:45 BST — source: Informix-list mailing list archive (1991-1998)

>From: "Wile E. Coyote" <wilec@nettaxi.com> >Reply-To: "Wile E. Coyote" <wilec@nettaxi.com> >To: informix-list@iiug.org >Subject: Re: index problem >Date: Fri, 09 Jun 2000 06:29:26 GMT >Received: from [206.175.175.254] by hotmail.com (3.2) with ESMTP id >MHotMailBB09E47C00A4D820F3A4CEAFAFFEF8930; Fri Jun 09 00:15:30 2000 >Received: (from majordom@localhost)by iiug.iiug.org (8.8.8+Sun/8.8.8) id >CAA18627;Fri, 9 Jun 2000 02:10:03 -0500 (CDT) >From owner-informix-list@iiug.iiug.org Fri Jun 09 00:17:00 2000 >Organization: ACME Bird Seed Bros. >Message-Id: <39408EF7.90BF0B66@nettaxi.com> >X-List-Gateway: comp.databases.informix >Sender: owner-informix-list@iiug.iiug.org >Precedence: bulk > >Fred, > >fm wrote: > > > > Hi Wile > > > > The firsrt index ist very slow! I need the second index (faster). The >first > > index is a date type and the between clause is very long (with for >example 2 > > monate) then i need first ix1 and than ix2.Do you understand ? > >I am not sure, whether I understood you right. You have two indexes, > > Index A (type date) > Index B (type ? maybe integer) > >Your number of returned rows using index A will be higher as the >number of rows in index B? > >Did you run "update statistics"? (standard question) >If yes, did you try an update statistics medium or high for the >columns in index A/B? > >Maybe, you have to do this to point your optimizer to the right way. Composite index on both fields? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com