Thank you very much
On 11-11-2017 13:15, m_brahi...@yahoo.fr [firebird-support] wrote:
>
>
> Thanks for the answers
>
>
> All fields contained in the PK are updated is that mean by operations
> affected ?
>
> decrease in
> performance is acceptable or not is up to you.>
> Thanks for explanation but if case
11.11.2017 13:15, m_brahi...@yahoo.fr [firebird-support] wrote:
> All fields contained in the PK are updated is that mean by operations
> affected ?
No. Operations are: select, insert, update, delete. Update may change PK
values or not,
select can do index scan or full scan. All this are
Thanks for the answers
All fields contained in the PK are updated is that mean by operations
affected ?
Thanks for explanation but if case of decreasing does we need to reindex table
manually ?
On 11-11-2017 11:13, m_brahi...@yahoo.fr [firebird-support] wrote:
> I need to know please if it is allowed that a primary key has multiple
> integer fields ? and only that. For example a PK that has seven integer
> fields will it decrease the performance table ? I am using FB 3. Thanks
Of
11.11.2017 11:13, m_brahi...@yahoo.fr [firebird-support] wrote:
> I need to know please if it is allowed that a primary key has multiple
> integer fields ?
Yes, but usually it is a sign of a bad database design.
> a PK that has seven integer fields will it decrease the performance table ?
Hello,
I need to know please if it is allowed that a primary key has multiple integer
fields ? and only that. For example a PK that has seven integer fields will it
decrease the performance table ? I am using FB 3. Thanks