26.12.2019 15:12, ertan.kucuko...@1nar.com.tr [firebird-support] wrote:
> I did not
> understand how I should be re-writing my sample SQL.
Just remove "left".
--
WBR, SD.
Hello,
I am not good at SQL optimization at all. Unfortunately, I did not
understand how I should be re-writing my sample SQL.
Would you post a sample SQL which should run faster, please?
Thanks & regards,
Ertan Küçükoğlu
-Original Message-
From: firebird-support@yahoogroups.com
26.12.2019 13:11, ertan.kucuko...@1nar.com.tr [firebird-support] wrote:
> left join
Left join here can unnecessary kill performance. There cannot be fields
without
corresponding table.
--
WBR, SD.
Hello,
I came up with following SQL in order to list calculated fields in a table
select rdb$relation_fields.rdb$field_name from rdb$fields
left join rdb$relation_fields on rdb$relation_fields.rdb$field_source =
rdb$fields.rdb$field_name
where rdb$computed_blr is not null and rdb$relation_name =
26.12.2019 11:53, ertan.kucuko...@1nar.com.tr [firebird-support] wrote:
> I need to identify columns in a table created as "computed by"
These columns have DRB$FIELDS.RDB$COMPUTED_BLR not NULL.
--
WBR, SD.
Hello,
I am using Firebird 2.5.9 on Windows OS.
I need to identify columns in a table created as "computed by"
If I check rdb$relations I only see them as float fields. However, database
tools are able to see their column type as "computed by ..."
Any help is appreciated.
Thanks & regards,