Subject | How to retrieve execution plan? |
---|---|
Author | harri007et |
Post date | 2004-02-14T17:19:12Z |
Hi!
Using delphi7+fibplus5+firebird.
Is the following pseudo-code possible with the current api?
---
assign query text;
prepare/retreive execution plan;
if WordCount('NATURAL') inside plan <= 2 then
execute query
else
error 'BAD query plan, try again';
---
FB1 has PLANONLY option, but this is "isql only"
regards,
Harri
Using delphi7+fibplus5+firebird.
Is the following pseudo-code possible with the current api?
---
assign query text;
prepare/retreive execution plan;
if WordCount('NATURAL') inside plan <= 2 then
execute query
else
error 'BAD query plan, try again';
---
FB1 has PLANONLY option, but this is "isql only"
regards,
Harri