DESIGNER_DESIGN_PROJECTION_ENCODINGS
Analyzes encoding in the specified projections, creates a script to implement encoding recommendations, and optionally deploys the recommendations.
Behavior Type
Syntax
DESIGNER_DESIGN_PROJECTION_ENCODINGS ( '[ proj‑spec[,... ] ]', '[destination]' [, 'deploy'] [, 'reanalyze-encodings'] )
Parameters
proj‑spec[,...]
|
One or more comma-delimited projections to add to the design. Each projection can be specified in one of the following ways:
If set to an empty string, Vertica analyzes all projections in the database to which the user has access. For example, the following statement specifies to analyze all projections in schema => SELECT DESIGNER_DESIGN_PROJECTION_ENCODINGS ('mydb.private.*','encodings.sql'); |
destination |
Specifies where to send output, one of the following:
|
deploy |
Boolean that optionally specifies whether to deploy encoding changes, by default set to |
reanalyze‑encodings |
Boolean that optionally specifies whether
|
Privileges
The following requirements pertain to the target projections:
- OWNER of all projections to analyze
- USAGE privilege on the schema for the specified projections
Examples
The following example requests that Database Designer analyze encodings of all projections in the schema online_sales
, and save output to the file encodings.sql
. The last parameter is omitted, so Database Designer does not execute the script:
=> SELECT DESIGNER_DESIGN_PROJECTION_ENCODINGS ('online_sales.*', 'encodings.sql'); DESIGNER_DESIGN_PROJECTION_ENCODINGS -------------------------------------- (1 row)