Subject Re: [IBO] Help04. Nested SELECT statements in TIB_Query: PLANs
Author Raymond Kennington
Svein Erling Tysvaer wrote:
> >So is SQLPlan something that I read and not something that I enter?
> I don't know whether this is a read only property or not. Normally I try to
> avoid writing plans explicitly (for PKs etc. the name could change
> following a restore) and rather tweak my SQL statement so that the
> optimizer selects a sensible plan. If I have to specify a plan, I would
> write it in the SQL statement itself. Is there anyone out there explicitly
> setting the SQLPlan?
I've been informed that it is a read-only property.

(With FB1.5 named PKs & FKs will be possible and I will define PLANs to speed up preparing
the SELECT statements.)
Raymond Kennington
Programming Solutions
W2W Team B