Posted: 20 Jun 2018 3:21 EDT Last activity: 9 Jul 2018 3:18 EDT
Why are there 9 non-used DB columns like pxCreateDateTime in an auto-generated declare index table?
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?
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.