Posted: 28 May 2019 3:02 EDT Last activity: 29 May 2019 13:05 EDT
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***
If the only data in which you have an interest is in the exposed column, I see no reason to burden the table with the blob content. Especially since you see that the system-defined index tables don't have a blob. Get rid of it!