RE: Must Read for Every Developer and DBA

>I thought that bind variables were faster
>but you always have to ensure that
>if you're accessing by data which may be
>heavily skewed and histograms would
>usually help you may not want to use
>bind variables as they will disable
>the use of histograms.

What will happen if i don't use bind variables and use CURSOR_SHARING = FORCE

Will the use of histograms be enabled or disabled in such a case?

Any disadvantages of using cursor_sharing=force?

Naveen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).