It is considered a best practice to use single table storage for searchable keywords, as well as in instances where one keyword on a document changes constantly (e.g., Workflow Status keywords). Use single table storage for alphanumeric keywords, unless a dynamically populated drop-down list is required. When a dynamically populated drop-down list is required, it is considered a best practice to use dual table storage. Dual table storage should only be used when a dynamically populated drop-down list is required.
Database statistics tend to be more accurate for single table keywords than dual table keywords because OnBase considers both the actual Keyword Values and frequency of occurrence. For dual table keywords, OnBase considers all Keyword Values to be equally likely to occur. Treatment of all Keyword Values as equally likely to occur causes longer running queries when data is unevenly distributed and concentrated around a few Keyword Values.