Subject | RE: [firebird-support] Retrieve query plan with SQL? |
---|---|
Author | RB Smissaert |
Post date | 2007-10-25T09:09:05Z |
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?
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]
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,from
> without actually running that query? If not is there any way to do this
> 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]