You haven't said how you connect to Firebird. Myself, I use Delphi with IBO, and that is very different from using Delphi with other component sets. But for getting a query plan, I normally just prepare my query in DB Workbench. The same thing should be possible using freeware tools like IB_SQL (I know this is easy) or FlameRobin (which I haven't tried). isql (part of Firebird) should also have some way of preparing queries, I think.

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of bartsmissaert@...
Sent: 25. oktober 2007 12:16
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Retrieve query plan with SQL?

Yes, I know about Google and had a good go at that, but no progress. I
thought maybe somebody on this forum who codes in VB may have done this.

RBS

> Hi,
>
>
>> OK, so how would I do that from VB? I am not familiar with the FB API.
>
> I have no idea how this works with VB :-)
>
> Google is your friend?
>
>> > Is it possible in FB 2.0 to retrieve the query plan of a query in SQL,
>> > without actually running that query? If not is there any way to do
>> this
>> from
>> > VB?
>>
>> One thing though, you cannot get it by using "sql", you need to retrieve
>> the actual plan by using an API call.
>
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
> &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com