Re: what does the +0 do ?

In environments which use Oracle's Cost-Based Optimizer, this will negate the use of an index (which would have been created on col_id) You would want to do this if a large number of col_id rows had the same value because a single full-table scan would be more efficient than bouncing back and forth from the index to the table.

<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 - 19:39:33 CDT