TALBJ Member since 2010 16 posts
Posted: 1 year ago
Last activity: 1 year 3 months ago

Blobs in Declare Index

We have an application in Production that we would like to take the data from to populate a test environment, masking the sensitive data as we do that.

Some of this sensitive data is in columns of Declare Indexes, and when the indexes were built the default pzPVStream was left there. When we open that class and run Test Connection, we get a warning that the blob is likely to affect performance. Is it recommended to remove the blobs from Declare Index tables? None of the OOTB PRPC index tables seem to have a blob.

Removing the blobs would significantly simplify the data masking.

***Edited by Moderator: Lochan to update platform capability tags***

Low-Code App Development Data Integration
Moderation Team has archived post
Share this page LinkedIn