Request performance is directly proportional to the size of the set of tables accessed. As table size increases, Vantage requires additional I/O operations to retrieve or update data.
For large tables that cannot be reduced in size, you can use the secondary index, single-table join index, primary index, primary AMP index, and partitioning features to limit the portion of a table that must be scanned to access needed data.