This options tells IQ to create a "1-Byte Fast Projection" index on all the columns (versus a Flat/Fast Projection index). This is good for some tables .. but, not good for others.
When Minimize_Storage=On is beneficial
- Table does not have a lot of columns ( < 40 )
- Table would benefit from compression as a lot of the data is repeated (e.g. State, Street, Ticker, Area Code, First Name, Salary in 000's, Color, Price (rounded). )
- Many/most of the columns are used in typical queries' where clauses
When Minimize_Storage=On is bad
- Table has a lot of columns (over 50)
- Table has a lot of complex numeric data or notations (e.g. price, # shares, position, currency rate, earnings, + any calculated #'s, text / notes )
- Most of the columns never appear in the where clause
|
|
