Re: Why Does Query Require Table Access

From: Jonathan Lewis <>
Date: Fri, 30 Jan 2009 20:35:48 -0000
Message-ID: <>

"Shakespeare" <> wrote in message news:49832466$0$183$

> Would Oracle be so clever to avoid to read the table when one uses:
> trunc(business_date) = to_date(....)?

Unfortunately not. But you might expect things to behave very nicely if you had a constraint with for condition - especially if you also declare business_date to be non-null. Unfortunately that doesn't work either, although 11g is a little tidier about what it does than 9i.


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ
Received on Fri Jan 30 2009 - 14:35:48 CST

Original text of this message