Re: index problem

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. Wile