In message <1118343433.188218.106010_at_g47g2000cwa.googlegroups.com>,
andyho99_at_yahoo.com writes
>Hi,
>
>I was wondering why people put "+ 0" after a column when creating view.
>
>
>For example,
>
>CREATE OR REPLACE FORCE VIEW APPS.PER_ADDRESSES_V (a, b, c) as
>select a,
> b + 0 b,
> c
>.
>.
>.
>
It disables use of an index on the underlying column
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Fri Jun 10 2005 - 01:59:18 CDT
