RE: Resource for index

> Friends :
>
> I have a part of statment as below :
>
> select column1 from table1
> where column1 = v_parameter;
>
> The column1 is not indexed, so the table full scan will be executed.
> Right?
> Well, I would like to know if anyone knows the resource :
>
> select column1 from table1
> where column1 = v_parameter +0
>
> What does it mean (+0).
> What kind of resource is it ?
> What does it do ?
>
> Best Regards
>
> Eriovaldo

Eriovaldo,

   Don't understand too well what you mean by 'resource'. One of the most cunning performance tips of yore was to either concatenate an empty string to a string or date column or add a zero to a number column to prevent the RBO from using an index on this column (BTW it's a trick which can still be useful at times) when this index was known to be not very selective.
Quite obviously, applying this to the constant part of an equality is totally pointless. And since the column is unindexed, it wouldn't have much utility either on the other side of the equality. Another case of ill-digested and ill-understood trick.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).