Re: SPL DATETIME bug ????
may be is the fact that the variables are of type string?
If they are datetime variables the it migth be the fact that they are variables not constants as in the prior example, and of course that might be a performance problem.
Chucho!
-----Original Message-----
From: Paul Watson <paul@oninit.com>
To: informix-list@iiug.org
Date: Wed, 29 Dec 2004 10:19:23 +0000
Subject: 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 #
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
sending to informix-list