Operating on Vertices - Aster Execution Engine

Teradata Aster® Developer Guide

Product
Aster Execution Engine
Release Number
7.00.02
Published
July 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
xnl1494366523182.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
ffu1489104705746
lifecycle
previous
Product Category
Software

It is generally a good idea to keep the Vertex and Edge objects as small as possible because SQL-GR wants to keep these objects in memory, in their entirety. If there are too many large objects, SQL-GR moves the objects to disk, which negatively affects performance. The smaller the objects, the less the memory used by SQL-GR. It is also a good practice to keep the messages small because they only reside in memory.