At 04:23 PM 1/26/2004, Alan McDonald wrote:

>so if you add a table to the db, you need to go around and increase the size
>of all your references to this variable? How is that efficient?

No. The db_key is a property of a record in a table or view. For a
table, its an eight byte binary quantity. For a view its length depends
on the number of input streams. I say "stream" rather than table
because a two-way reflexive join involves only one table but has a
16 byte db_key, and a three way reflexive join still involves only
one table but has a 24 byte db_key.

Regards,


Ann