Re: Need help rewriting SQL with TRUNC function

>
>I think that the following statement is keeping this application from using
>an index in my cost-based execution plan. This is an 8.0.4 database so I
>don't have the option of creating a function-based index.
>
>I'm not that great with SQL. Can anyone help me rewrite this statement so
>that I don't need to use the TRUNC function on this column in blue?
>
> (trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 AND
>
>Thanks,
>
>Cherie Machler
>Oracle DBA
>Gelco Information Network
>

erh.arrival_dt <= trunc(sysdate) - 7 should give exactly the same result, even without the second trunc().
Try a count(*) with both versions if you have any doubt.

--
Diese E-Mail wurde mit http://www.mail-inspector.de verschickt
Mail Inspector ist ein kostenloser Service von http://www.is-fun.net
Der Absender dieser E-Mail hatte die IP: 194.51.96.14

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).