Is there any option to reduce space usage for varchar type columns when the values for some of the columns may be repeated, below is an example dataset:
SYSPLEX SYSTEM SUBSYSTEM ---------------------------------------------------------------------------- PLEX1 CA11 SBS1 PLEX1 CA11 SBS2 PLEX1 CA31 SBS3 PLEX1 CA31 SBS4 this is a very small example dataset but hope it gets the point across that what I'm looking for is a way to make h2 store the repeated strings "PLEX1", "CA11", "CA31" only once and use internal id's instead to save disk space when there any many many rows like this with much more columns. Is it possible to do so with some configuration option? I couldn't find something like this going through the various documentation or forum posts here but may be I missed something. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
