Subject | Re: [firebird-support] Retrieve query plan with SQL? |
---|---|
Author | Kjell Rilbe |
Post date | 2007-10-25T19:02:56Z |
Have a look at how external functions are declared in VB:s API text
viewer. Based on that, try to figure out how the Firebird API:s would
map to such VB function declarations. It shouldn't be too hard I hope.
Kjell
bartsmissaert@... wrote:
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
viewer. Based on that, try to figure out how the Firebird API:s would
map to such VB function declarations. It shouldn't be too hard I hope.
Kjell
bartsmissaert@... wrote:
> 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.
>>
>>>OK, so how would I do that from VB? I am not familiar with the FB API.
>>>
>>>>One thing though, you cannot get it by using "sql", you need to retrieve
>>>>the actual plan by using an API call.
>>>>
>>>>>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?
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64