Hi all,

I need to optimize this SQL query:

SELECT * FROM Gloparams G1 WHERE ;

cImeVar =3D tcImeVar AND ;

dVrijediOd =3D ;

( SELECT MAX( dVrijediOd ) FROM Gloparams G2 ;

WHERE g2.dVrijediOd <=3D tdDatum) INTO cursor TekVar

For purpose of optimization, I think GloParams table should be indexed wi=

th

INDEX ON cImeVar TAG cImeVar

INDEX ON dVrijediOd TAG dVrijediOd

Am I correct?

--

---

Zoran Ljubi=B9i=E6

powersoft@bj.tel.hr