Troubleshooting
Problem
Vertica doesn't use indexes to find the data. Conceptually, you still access tables using SQL. But underneath the hood, the data in the table are stored in projections, which you can optimize for different queries. This note is trying to provide you with some details about how to create projections to tune up PA performance.
[{"Product":{"code":"SSZTRM","label":"IBM Spectrum LSF Analytics Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1.4","Edition":"Advanced","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
30 August 2019
UID
isg3T1025058