Zoran:

I believe you are correct.

Dan Covill

Middleton Consulting, San Diego

At 12:41 03/22/01 +0100, you wrote:

>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 with

>

>INDEX ON cImeVar TAG cImeVar

>INDEX ON dVrijediOd TAG dVrijediOd

>

>Am I correct?

>

>Zoran Ljubi=B9i=E6

>powersoft@bj.tel.hr

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