SPL DATETIME bug ????

This is all in SPL, Solaris 8, 9.40UC3 select count(*) from table1, table2 where join and datetime between "2004-09-29 09:57:58.00" AND "2004-12-29 09:57:58.00" returns 0.3 seconds but let l_dte1 = "2004-09-29 09:57:58.00" let l_dte2 = "2004-12-29 09:57:58.00" select count(*) from table1, table2 where join and datetime between l_dte1 and l_dte2 returns 6.5 seconds The query plan is identical in both, all datetimes are y-f2 Any straws gratefully grasped -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #