Subject Re: [firebird-support] Retrieve query plan with SQL?
Author bartsmissaert@blueyonder.co.uk
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
>
>