Re: [firebird-support] Identify computed by columns in table

2019-12-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.

RE: [firebird-support] Identify computed by columns in table

2019-12-26 Thread ertan.kucuko...@1nar.com.tr [firebird-support]
Sent: Thursday, December 26, 2019 4:57 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Identify computed by columns in table 26.12.2019 13:11, ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > left join Left join here can unnecessary kill performance. There

Re: [firebird-support] Identify computed by columns in table

2019-12-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.

RE: [firebird-support] Identify computed by columns in table

2019-12-26 Thread ertan.kucuko...@1nar.com.tr [firebird-support]
: [firebird-support] Identify computed by columns in table 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. -

Re: [firebird-support] Identify computed by columns in table

2019-12-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.