Re: Natural keys vs Aritficial Keys
From: --CELKO-- <jcelko212_at_earthlink.net>
Date: Sun, 17 May 2009 07:05:56 -0700 (PDT)
Message-ID: <e697c700-0e7d-4131-8582-0a62b7476089_at_l32g2000vba.googlegroups.com>
Date: Sun, 17 May 2009 07:05:56 -0700 (PDT)
Message-ID: <e697c700-0e7d-4131-8582-0a62b7476089_at_l32g2000vba.googlegroups.com>
Ever work with DBs that use hashing instead of tree indexes? Longer keys are better because there is less chance of a hash collision. There is also a lot of work being done on minimal perfect hashing right now. This is going to be very important for VLDB because unlike indexes, a hash requires only one probe. Received on Sun May 17 2009 - 16:05:56 CEST