On Tue, 7 Mar 2006, Jonah H. Harris wrote:
> On 3/7/06, Stephan Szabo <[EMAIL PROTECTED]> wrote:
> >
> > I'd personally be more interested in what the impact is on people not
> > using synonyms. How free is any search for synonyms if you aren't using
> > the feature?
>
>
> Unless synonym enablement were a configurable parameter (which wouldn't
> really make sense), the cost would be the same whether they're used or not
> during searching.
Right, but the response was that "using" synonyms incurred a cost and this
should be documented. However, if there's a cost to people not using
synonyms there's a higher barrier to entry for the feature.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
