Subject RE: [firebird-support] How Firebird Indexes GUID fields?
Author Alan McDonald
> Hi folks,
>
>
> I was just wondering if those in the know would mind telling me how
> Firebird indexes GUID fields, and in particular what bytes are of
> primary importance?
>
> I have been reading the article:
>
> The Cost of GUIDs as Primary Keys
> http://www.informit.com/articles/article.asp?p=25862
>
> and am wondering how Firebird indexes the GUID field values, and how to
> write a a COMB type class that produces a GUID value optimized for
> Firebird indexing.
>
> I eagerly look forward to the discussion.
>
>
> Regards,
>
>
> Scott Price :)

there's a UDF function around which generates UUIDs with reversed
significance. That's what you need for indexing in FB.
Alan