|Subject||Re: [IBO] Help04. Nested SELECT statements in TIB_Query: PLANs|
|Author||Svein Erling Tysvaer|
>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?