index problem

Posted in 2000

fm — Thu, 8 Jun 2000 16:21:33 +0200 — source: Informix-list mailing list archive (1991-1998)

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