Date and timestamp comparision

From: Debaditya Chatterjee <>
Date: Wed, 4 Jun 2008 15:18:45 -0400
Message-ID: <>


I am facing a performance problem which is caused due to comparing a date column with a TIMESTAMP variable. We are using Siebel Analytics (on 10gR2) and all date variables from the Siebel side are passed as timestamp e.g. TIMESTAMP '2008-02-29 00:00:00'. In the execution plan we see the following conversion



which prevents the index on creation_date to be picked up. When I change the sql manually to use a TO_DATE function the index is used and the query runs much faster.

This article describes the issue but none of the solutions can be implemented quickly (while some them are not acceptable).

I was hoping if this is a known issue and anybody has a fix purely on the database side.


Received on Wed Jun 04 2008 - 14:18:45 CDT

Original text of this message