he columns with the following data types should not be part of any DISTRIBUTION key selected for any given table:- TEXT is data type with unlimited length. A very noxious data type.
- DECIMAL not to be used at all in the DISTRIBUTION key
- DOUBLE-PRECISSION (Floating-Point binary64)
- REAL or real number
- SERIAL mimics a good sequential number but panelizes a Singleton Select JOIN practice
- BIGSERIAL
- MONEY which stores a monetary types of data (it has been deprecated)
- Boolean types (0/1, true/false, etc)
- Bytea Type
|
|
