Skip navigation
All Places > All Things PI - Ask, Discuss, Connect > Ideas

Option to split date and time into separate columns

score 2
You have not voted Submitted

Originally posted on UserVoice
SAP recommends using compression on column store databases to conserve RAM and disk space resources (https://blogs.sap.com/2016/08/12/how-and-why-to-do-compression-of-column-store-tables-in-sap-hana/). Since date+time values are typically unique and compression in SAP HANA is column-based, compression of timeseries data like the data published by the Integrator is more effective if date and time are in separate columns as opposed to a single time column containing both date and time.

Comments