I connect via ODBC with the standard Firebird ODBC driver.

I know I can get the query plan with FlameRobin (didn’t know IB_SQL worked
with FB as well), but I would like to get it programmatically in VB.



RBS



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling Tysvær
Sent: 25 October 2007 11:53
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Retrieve query plan with SQL?



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@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com [mailto:firebird-support@
<mailto:firebird-support%40yahoogroups.com> yahoogroups.com] On Behalf Of
bartsmissaert@ <mailto:bartsmissaert%40blueyonder.co.uk> blueyonder.co.uk
Sent: 25. oktober 2007 12:16
To: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
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. <http://www.upscene.com> com
> My thoughts:
> http://blog. <http://blog.upscene.com/martijn/> upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.database <http://www.databasedevelopmentforum.com>

developmentforum.com





[Non-text portions of this message have been removed]