Distribute the load across Vertica initiator nodes - Connect_ETL - 9.13

Connect ETL Vertica Load Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
Language
English
Product name
Connect ETL
Title
Connect ETL Vertica Load Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-11
ft:lastPublication
2023-09-11T19:09:11.694437

After the data is loaded to the nodes of the Vertica database, Vertica distributes the load across the data nodes using an optimization strategy known as projections. Vertica recommends that you enable automatic projections initially. Later, you may choose to use the Vertica Database Designer to manually create projections that optimize your database based on the characteristics of the data and, optionally, the queries you use.

For information on Vertica projections, see the “Automatic projection creation” topic in the Configuring the Database section of the Vertica Enterprise Administrator’s Guide.