Re: star transformation not chosen because of bind variables

From: Richard Foote <richard.foote_at_bigpond.com>
Date: 25 Sep 2003 23:55:56 -0700
Message-ID: <69f6c1c8.0309252255.49231fbf@posting.google.com>

jimreesman_at_yahoo.com (Jim Reesman) wrote in message news:<ef9d9e.0309251232.7d247cad_at_posting.google.com>...
> In the following listing, the first query has 2 literal values in the
> where clause. It results in a star transformation being chosen and the
> plan and response time are good. The second query has simply had the 2
> literals replaced with bind variables. Despite including the
> STAR_TRANSFORMATION hint, the CBO chooses the full scan and index
> range scans (it does so seemingly without regard to _any_ hints - eg.
> FACT () ).
>

Hi Jim,

Try putting the hint immediately after the SELECT /*+ here */ keyword.

Cheers

Richard Received on Fri Sep 26 2003 - 01:55:56 CDT