optimization pb
From: FJ <franck_jeff_at_hotmail.com>
Date: 26 Mar 2003 07:55:21 -0800
Message-ID: <c9bdc2f0.0303260755.1fcaa05f_at_posting.google.com>
Date: 26 Mar 2003 07:55:21 -0800
Message-ID: <c9bdc2f0.0303260755.1fcaa05f_at_posting.google.com>
Hi all,
I do have a stored proc, with a simple select containing few joins.
and in my conditions I have something like:
where DCREATED >= dfrom
and t.DCREATED < dto
if dfrom and dto are taken in the SP parameters, the execution would
take 8 sec
and if I put the dates in hard in the proc like:
where DCREATED >= '01-JAN-2000'
and t.DCREATED < '20-MAR-2003'
It takes 0.5 sec.
Do any of you have an idea ? Thanks. Franck Received on Wed Mar 26 2003 - 16:55:21 CET