Subject Re: [firebird-support] Re: Best way to delete millions of rows
Author Dimitry Sibiryakov
22.11.2016 21:01, 'Leyne, Sean' Sean@... [firebird-support] wrote:
>> There would be a lot of advantage, for Firebird, in using this kind of guid?
> Yes, Firebird indexes use prefix compression so the leading 14 chars of the above values
> would be stored under a single entry.

For that Microsoft invented "sequential GUID" quite a lot time ago.

BTW: CHAR(16) CHARACTER SET OCTETS is a better way to keep GUID in database.