Re: index problem
From: "fm" <fm@ils-consult.at>
>
>I have 2 indexes: ix1 and ix2 !
>I would like that the engine take first ix1 and then ix2 ....
>(sqexplain.out)
>
>I have ;
>
>select xxx from tab1, tab2 wehre>tab1.ix1= .... and tab2.ix2=....
>
>in sqexplain.out :
>
>
>1) INDEX PATH
>ix2
>2) INDEX PATH
>ix1
>
>but i need
>
>1) INDEX PATH
>ix1
>2)INDEX PATH
>ix2
>
>(with informix 7.3)
>
>how kann i do that ?
>
>sorry for my very bad english ! un thank you very much for your help !
Are you sure it's actually a problem? Anyway, have you done UPDATE
STATISTICS?
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com