>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