If I run the optimize wizard for a page list, it will auto-generate a DB table. I noticed that 9 columns are created that are always empty, and it seems better to just drop these columns. Is there any reason not to drop those columns?
These are populated, if you copy them from source in Declare Index Rules.
I have use cases in one of the applications where i use these fields from Index tables in PR_INDEX_DATA_AGENTS or PR_INDEX_OPERATOR_WORKGROUPS for auditing purposes.
Guideline i follow us, if the columns are there on source table, i will retain them on Index table.
Posted: 4 years ago
Posted: 20 Jun 2018 7:24 EDT
Maarten Veger (MaartenBPM)
Managing Consultant & Pega CLSA
Ok, sometimes it might be handy but to always populate that but in most situations not. In my use case, there is no added value of having these as the declare index is meant for reporting purposes on the page list. The pxCreate* and pxUpdate* properties would come from the case table.