sql statement takes too long non-optimesed

[KoenPiller]

Hi,
I cant get this select statement optimized, it takes too long:

Select myCursor.productnmr, ;
       myCursor.startingdate, ;
       sum(myCursor.productive) as productive ;
  from myCursor ;
  join products on products.productnmr = myCursor.productnmr ;
 where myCursor.startingdate between(product.startingdate and product.endingdate) ;
  into cursor curProductiveactive

Nb products has an index on startingdate, endingdate and productnmr

Just hope on someone around who could help me with this one.

Thanks,

Koen

 

[Mike Lewis]

Olaf,

I believe the tables were created in VFP 8.0, but I'm not sure. But I don't see why it is relevant.

Whatever changes have taken place in index or table structures between versions, that has nothing to do with my original assertion: that WHERE and JOIN are identical, performance-wise.


Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)