title: How to reduce data redundancy of text field in database
body: <p>I am using a OLAP system, some of table has text field. the text length can be from some Bytes to KB, while the size of other fix size fields in one row is only about 100 Bytes. </p>
  
  <p>some of my tables have billions of rows and the value of text field is highly repeatable, how can i reduce this kind of redundancy to save the storage space and does not lose query performance?</p>