On 24-2-2018 11:40, antoedinchar...@gmail.com [firebird-support] wrote:
> 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
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
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