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
How to (optionally) get Firebird 3 query plan?
Re: How to (optionally) get Firebird 3 query plan?
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?
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
With regards,
Martijn Tonies
Re: How to (optionally) get Firebird 3 query plan?
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?
Thank you, please make it optional, as parsing the new output is very different, and it's much longer too.
With regards,
Martijn Tonies
With regards,
Martijn Tonies
Re: How to (optionally) get Firebird 3 query plan?
We plan to add isc_info_sql_get_plan in one of the next releases of IBDAC.