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