Subject RE: [firebird-support] Retrieve query plan with SQL?
Author RB Smissaert
OK, so how would I do that from VB? I am not familiar with the FB API.



RBS



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: 22 October 2007 14:17
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Retrieve query plan with SQL?





> 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]