Page 1 of 1
How to (optionally) get Firebird 3 query plan?
Posted: Wed 28 Feb 2018 12:33
by upscene
Hi,
Firebird 3 has a new query plan, see
https://firebirdsql.org/file/documentat ... utput.html
According to the Firebird support list, you can get the new plan output programmatically
"Pass isc_info_sql_explain_plan (value 26) into isc_dsql_info() instead of isc_info_sql_get_plan (value 22)"
Any way this can be done using the component set yet?
With regards,
Martijn Tonies
Re: How to (optionally) get Firebird 3 query plan?
Posted: Wed 28 Feb 2018 14:54
by ViktorV
At the moment, IBDAC does not support the installation of isc_info_sql_get_plan. We will consider the possibility of adding this functionality. We will consider a possibility of the specified functionality in one of the next IBDAC version. If you want us to implement the feature, please post it at our user voice forum:
https://devart.uservoice.com/forums/104 ... e-firebird. If the suggestion gets a lot of votes, we will consider the possibility to implement it.
Re: How to (optionally) get Firebird 3 query plan?
Posted: Tue 06 Mar 2018 08:17
by upscene
This is an important Firebird 3 feature. Why should people have to 'vote' for this? It should be part of the readiness of your component set for Firebird 3.
With regards,
Martijn Tonies
Re: How to (optionally) get Firebird 3 query plan?
Posted: Tue 06 Mar 2018 13:45
by ViktorV
We plan to add isc_info_sql_get_plan in one of the next releases of IBDAC.
Re: How to (optionally) get Firebird 3 query plan?
Posted: Tue 06 Mar 2018 13:48
by upscene
Thank you, please make it optional, as parsing the new output is very different, and it's much longer too.
With regards,
Martijn Tonies
Re: How to (optionally) get Firebird 3 query plan?
Posted: Tue 06 Mar 2018 13:56
by ViktorV
We plan to add isc_info_sql_get_plan in one of the next releases of IBDAC.