Re: [firebird-support] Composite Primary Key in JOIN - performance

2015-08-14 Thread Steve Declerck steve.decle...@yahoo.com [firebird-support]
Hi Ann, Thanks a lot for your reply. I'm happy to know that I shouldn't worry too much about the compound keys. I will look deeper into the queries. Thanks and best regards, Steve On Tuesday, August 11, 2015 4:09 PM, Ann Harrison aharri...@ibphoenix.com [firebird-support]

[firebird-support] Composite Primary Key in JOIN - performance

2015-08-11 Thread steve.decle...@yahoo.com [firebird-support]
Goodmorning, I have to continue to work on a existing ERP program with an existing FB database. I don't like the design very much, looks messy and the original designer didn't think twice a lot from what I see. Example, when I take a look at the small lookup tables used to store payment

Re: [firebird-support] Composite Primary Key in JOIN - performance

2015-08-11 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 11, 2015, at 4:59 AM, steve.decle...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: ...when I take a look at the small lookup tables used to store payment conditions, currency codes, titles, etc, the primary key is always VARCHAR(4) to either store a