Re: star transformation not chosen because of bind variables

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Sun, 28 Sep 2003 20:34:21 +0300
Message-ID: <3f771b9e$1_1@news.estpak.ee>

> I can't wait to see the answer because from my experience hints are
> often ignored.

Yes, hints are definitely ignored when they can't be fulfilled. The simplest case would be to ignore an "index" hint when index plainly doesn't exist on required column. A hint involves a complex set of rules, which are first evaluated before any behaviour will be changed. Star transformation has several documented restrictions, which disable it's use, regardless of any hint or parameter setting.

Btw, there's a parameter _always_star_transformation which could be used in some cases when CBO doesn't want to use ST even though all required conditions have been fulfilled.

Tanel. Received on Sun Sep 28 2003 - 12:34:21 CDT