Re: [firebird-support] Firebird 3 advanced plan output > how to use this with the API?
Hello Mark, >>> m.ton...@upscene.com [firebird-support] wrote: I wonder, how can applications use this feature https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-dml-planoutput.html >>> >>> What do you mean? How to parse it, or how to get it? >> >> How to get it, without using isql. > >Vlad already answered that: > > > Pass isc_info_sql_explain_plan (value 26) into isc_dsql_info() >instead of isc_info_sql_get_plan (value 22) I missed that, thanks. With regards, Martijn Tonies Upscene Productions http://www.upscene.com
Re: [firebird-support] Firebird 3 advanced plan output > how to use this with the API?
On 28-2-2018 08:46, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: >> On 23-2-2018 11:58, 'Martijn Tonies (Upscene Productions)' >> m.ton...@upscene.com [firebird-support] wrote: >>> I wonder, how can applications use this feature >>> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-dml-planoutput.html >> >> What do you mean? How to parse it, or how to get it? > > How to get it, without using isql. Vlad already answered that: > Pass isc_info_sql_explain_plan (value 26) into isc_dsql_info() instead of isc_info_sql_get_plan (value 22) Mark -- Mark Rotteveel
Re: [firebird-support] Firebird 3 advanced plan output > how to use this with the API?
>On 23-2-2018 11:58, 'Martijn Tonies (Upscene Productions)' >m.ton...@upscene.com [firebird-support] wrote: >> I wonder, how can applications use this feature >> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-dml-planoutput.html > >What do you mean? How to parse it, or how to get it? How to get it, without using isql. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
Re: [firebird-support] Firebird 3 advanced plan output > how to use this with the API?
Hi, Martijn > How to get it, without using isql. Pass isc_info_sql_explain_plan (value 26) into isc_dsql_info() instead of isc_info_sql_get_plan (value 22) Regards, Vlad
Re: [firebird-support] Firebird 3 advanced plan output > how to use this with the API?
Hello Mark, How to get it, without using isql. With regards, Martijn Tonies Upscene Productions http://www.upscene.com -Original Message- From: Mark Rotteveel m...@lawinegevaar.nl [firebird-support] Sent: Friday, February 23, 2018 1:03 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Firebird 3 advanced plan output > how to use this with the API? On 23-2-2018 11:58, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: > I wonder, how can applications use this feature > https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-dml-planoutput.html What do you mean? How to parse it, or how to get it? Mark -- Mark Rotteveel Posted by: Mark Rotteveel ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] Firebird 3 advanced plan output > how to use this with the API?
On 23-2-2018 11:58, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: > I wonder, how can applications use this feature > https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-dml-planoutput.html What do you mean? How to parse it, or how to get it? Mark -- Mark Rotteveel