Re: [firebird-support] Foreign Key & Query Performance

Show query plans for both situatios fk an index. Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "antoedinchar...@gmail.com [firebird-support]" Data: 24.02.2018 11:40 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat:

[firebird-support] Foreign Key & Query Performance

Hello there, I am having a doubt that if Foreign Key reduces Query Performance Or not. My Environment is FirebirdCS2.6 :- Item Table :- 10 Records, PK - Itemcode Varchar(5); BillDetail Table :- 10 Million Records (FK Selectivity - 0.0076, PK Selectivity - 0.00076) I am having FK

[firebird-support] Firebird SQL 3.0 login from legacy tools?

Hi, New Windows 2016 server with Firebird 3 SuperServer x64 on port 3050. I'm trying to connect to this server from two legacy tools: Sinática Monitor and FlameRobin. I can successfully connect with Upscene Database Workbench and Firebird Maestro, but the old tools fail, saying "Your user