Remove Columns from Main Query
Remove columns that the user does not need from the main query object.
When removing columns from the main query object of a window or info box, remove them from the query rather than at interface level. ESI will now generate an interface without fields for these columns. This will speed up not only ESI retrieval but also data processing. This is because removed columns are not included in SQL processing. If you make unneeded columns non-displayed rather than removing them from the query statement, this will not improve performance.
When to use
If there are columns in the main query of a window or info box that the user does not need, and the application does not need either.
To remove a column from the main query:
Data manipulation is only possible if all mandatory columns are available.