121 Reputation

Activities(1) Posts(0) Series(0) Areas of Expertise Following Followers

rambo Commented on

Running TPC-H Benchmark on AnalyticDB PostgreSQL

This tutorial shows you how to run TPC-H benchmark on Alibaba Cloud AnalyticDB PostgreSQL

It's correct. There is no need to define a foreign key, index, etc., because it uses similar names in DDL for the columns that refer to the same value. For example, 'NATIONKEY' is configured as 'c_nationkey' in the CUSTOMER table and as 'n_nationkey' in the NATION table. Then when running the TPC query workload (DML), it uses a WHERE condition like 'WHERE c_nationkey = n_nationkey' to filter.
Areas of Expertise

Following (0)

See All

Followers (0)

See All
Latest Comments
No series yet.