I think Im beginning to understand the problem here but Im not
sure what the solution is

I have an index on villa_id and date in the v_avail table

IF I run this it is slow

select * from v_avail;
where villa_id=villas.idcode ;
and DATE>=thisform.fdate and DATE

Either one if the following runs fast

select * from v_avail;
where villa_id=villas.idcode ;
and DATE>=thisform.fdate

or

select * from v_avail;
where villa_id=villas.idcode ;
and DATE
However it seems to be the AND CLAUSE in the
DATE>=thisform.fdate AND DATEwhich is causing the problem.

Can I set up and index to accomodate this ?
or
Is there another workaround