Netezza没有传统意义的index， 用的是初始形态，分布式存储。 Architecture-MPP,SPU 方便大数据量的快速查询。distribution key与index类似，根据这个查找存储在哪个SPU上。 Considerations in Designing - distribution keys,data types, etc. 相同字段在不同表中设置了不同的data type，join的时候会转换。将int转换为varchar，字符串匹配比整型匹配慢很多。.......
The Netezza appliances integrate database, processing, and storage in a compact system optimized for analytical processing and designed for flexible growth. The system architecture is based on the following core tenets that have been a hallmark of N
