Re: what does the +0 do ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 25 Oct 2000 08:34:05 +0200
Message-ID: <972458425.17601.0.pluto.d4ee154e@news.demon.nl>

Force the index not to be used, so in this case force a full table scan. Whenever an indexed column is used in an expression on the left hand side of a comparison, any associated index will NOT be used.

Hth,

Sybrand Bakker, Oracle DBA

<bsc7080_at_mindspring.com> wrote in message news:r5bcvsgb2t80j3qdbcu6chvgu6n3ktfl7u_at_4ax.com...
> I have been running into this here at work (new job) but I do not know
> what it is doing ...
>
> select col1
> from table
> where col_id+0 = v_col_id;
>
> Where col_id is a number datatype.
>
> What does the +0 do ?
>
> enhance precision ?
> change indexing scheme ?
>
> Ideas ?
Received on Wed Oct 25 2000 - 01:34:05 CDT