Row Hash Persistent View
When enabled, the RowHash will be included in the Persistent views. Note: This may reduce performance during Data Vault table reloads.
When enabled, the view exposes the row hash, read from the persisted PSA row hash column when one exists, and otherwise computed inside the view from the hash pattern. When disabled and the row hash would normally be computed, the view returns the default key value in its place, avoiding the hash computation on every read.
When to Change This Setting
Keep the default N for faster reads of the persistent views. Enable it when downstream processing consumes the views and needs the row hash, accepting the computation cost when the hash is not persisted in the PSA.
Related Settings
| Setting | Interaction |
|---|---|
| Create Persistent View | Enables the persistent views this setting applies to |
| Hash Algorithm | The algorithm behind the row hash computation |
Notes
- This setting is part of the Staging settings category.
- The default value for this setting is
N.