"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news:J7adnUofN4bhy2CiRVn-sw_at_comcast.com...
> + 2 cents:
>
> the LIKE syntax would be preferable (assuming APNNUM is a varchar2, which
it
> seems to be if you're using SUBSTR to display it) since it would allow the
> optimizer to use an ordinary index -- the SUBSTR syntax would require a
> matching function-based index
absolutely, missed that the start position was the beginning of the field.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Thu Jan 08 2004 - 08:41:40 CST
