IS_HIDDEN flag on the events in the SS_STATUS_HISTORY table

Summary:

Understand the functionality of IS_HIDDEN in the SS_STATUS_HISTORY table and whether it can positively impact UI performance

Content (please ensure you mask any confidential information):

After extracting the information from our system through Analyzer Report, the following point caught my attention:

When I launch the image query in the PROD console, I get shipments with a high number of I_TRANSACTION_NO:

SELECT SHIPMENT_GID, COUNT(I_TRANSACTION_NO) COUNT, MIN(INSERT_DATE), MAX(INSERT_DATE) FROM SS_STATUS_HISTORY WHERE IS_HIDDEN = 'N' GROUP BY SHIPMENT_GID HAVING COUNT(SHIPMENT_GID) > 50 ORDER BY COUNT DESC