Re: index problem
En fm va escriure el dia 8 Jun 2000, a les 16:21:
> 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.
>
>
Try:
Select {+ORDERED} xxx
from tab1, tab2
where tab1.ix1 = ??? and
tab2.ix2 = ''' ....
I hope this helps.
---------------------------------------
Isidre PONS ROCA
BASE - Gesti' d'Ingressos Locals
(Diputacio de Tarragona)
Servei de Sistemes de Informacio
Av President Lluis Companys 12-C
43005 - Tarragona
SPAIN
Tel # +34 977 236731
Fax # +34 977 227302
http://www.altanet.org
ipons@dtgna.altanet.org
---------------------------------------