| Subject | Re: [firebird-support] Re: Best way to delete millions of rows |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2016-11-22T20:05:51Z |
22.11.2016 21:01, 'Leyne, Sean' Sean@... [firebird-support] wrote:
BTW: CHAR(16) CHARACTER SET OCTETS is a better way to keep GUID in database.
--
WBR, SD.
>> There would be a lot of advantage, for Firebird, in using this kind of guid?For that Microsoft invented "sequential GUID" quite a lot time ago.
>
> Yes, Firebird indexes use prefix compression so the leading 14 chars of the above values
> would be stored under a single entry.
BTW: CHAR(16) CHARACTER SET OCTETS is a better way to keep GUID in database.
--
WBR, SD.