Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Hashed Primary Key

Overview

Having a Hashed version of the primary key can speed up lookups from other tables, especially if the primary key consists of multiple alphanumerical fields.

Process

  • 1. Right click the table → Advanced → Advanced Settings

  • 2. Check the box for Enable BK Hash Key

    When that option is checked, the Jet Data Manager will generate a Hashed version of the Primary key fields(s) using the SHA1 Hashing Method. If no primary key is selected, then the BK_HASH_KEY will contain a hashed version of the DW_ID Field.

  • Published:

    Hashed Primary Key

    Overview

    Having a Hashed version of the primary key can speed up lookups from other tables, especially if the primary key consists of multiple alphanumerical fields.

    Process

  • 1. Right click the table → Advanced → Advanced Settings

  • 2. Check the box for Enable BK Hash Key

    When that option is checked, the Jet Data Manager will generate a Hashed version of the Primary key fields(s) using the SHA1 Hashing Method. If no primary key is selected, then the BK_HASH_KEY will contain a hashed version of the DW_ID Field.

  • For an optimal Community experience, Please view on Desktop