Subject Re: [Firebird-Architect] UUID sidetracks
Author Ann W. Harrison
Kevin Berry wrote:
> Like you I'm using a character field. For convenience
> I'm keeping the {}'s. Although it really wouldn't be
> hard to remove them. 38 char vs 36 char is really not
> going to have a big impact though! We're talking
> about around 5% increase in key size. Going from 38
> down to 16 would make a substantial difference though.

Key compression is nearly as large a factor in index size as the
original key size, and, for identifiers, prefix compression matters
most. If there is any way to arrange the key so that the parts that
don't change come first, you can reduce key size significantly - by half
or more.