Re: index problem
I believe you want to use an optimizer directive to identify the join order
for your query. the ordered directive will tell the optimizer to use the
order defined in the from clause. See section under optimizer directives in
the performance guide.
select {+ordered} xxx
from tab1, tab2 wehre
tab1.ix1= .... and tab2.ix2=....
HTH,
Ben
t
"fm" <fm@ils-consult.at> wrote in message
news:v3O%4.80$oB6.3861@nreader1.kpnqwest.net...
> Hi,
>
> 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 !
>
> fred.
>
>