🚀 go-pugleaf

Here is how to do it with isql:

1. Connect to database with isql
2. set plan on;
3. execute your query

If your query returns many records, it's advisable to replace a field 
list with count(*) so you won't be distracted with output. Either way, 
the plan is the same.

Note that this technique applies to all subsequent version of InterBase 
as well.

Using the API, call isc_dsql_sql_info() with the item 
isc_info_sql_get_plan to get a plan.

RB Smissaert wrote:
> How could I get access the API from VB?
> How would I do it with ISQL from the commandline?
> I might be able to use the last and direct the output to text and get 
> the plan from the text file.
> Using the API directly would be the best way.
> Thanks.
> 
> RBS
> 
> "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]> 
> wrote in message news:46f17982$1@newsgroups.borland.com...
>> RB Smissaert wrote:
>>
>>> Is there a way in plain SQL to retrieve the Interbase query plan
>>> given a particular query?
>>
>> No. You need to use the API for this, either directly or with a
>> component set like IBX. You can also do it in command-line ISQL.
>>
>> -- 
>> Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
>>  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
>> All the great TeamB service you've come to expect plus (New!)
>>  Irish Tin Whistle tips: http://learningtowhistle.blogspot.com 
>