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
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:
Hi Neil,
I also have that experience when restoring. But as you said only when there are
problems in the underlying table. Like duplicate values in a column that has a
unique index.
In that case i can only reenable the index when fixing the table. In the cases
I'm talking about there are no obv
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 h
I know from experience that a restore can sometimes leave indexes in a
disabled state, and you would usually get an error when trying to
activate it as it was left disabled during the restore phase due to a
minor data issue. The errorlevel returned by GBAK is greater than 0 so
you can detect when t
Hi,
I'm using firebird embedded (2.5 and 3) in an on-premise solution. I get
sometimes reports of slow behaviour and when checking those databases I can see
that some or all indexes are disabled.
I can than simply enable those indexes and all seems well afterwards. Gfix does
not find any proble
Hi,
I wonder, how can applications use this feature
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-dml-planoutput.html
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, Postgr