大家看到题目可能会想,建表谁不会呀,还用讲嘛?但是如何建表能使你的应用查询更加快呢?
####Anatomy of a Projection
The [CREATE PROJECTION]statement defines the individual elements of a projection, as the following graphic shows.
The previous example contains the following significant elements:
####Column List and Encoding
Lists every column in the projection and defines the encoding for each column. Unlike traditional database architectures, HP Vertica operates on encoded data representations. Therefore, HP recommends that you use data encoding because it results in less disk I/O.
####Base Query
Identifies all the columns to incorporate in the projection through column name and table name references. The base query for large table projections can contain PK/FK joins to smaller tables.
####Sort