Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ FAQs/ What Are the Application Scenarios of Replication Tables?
Updated on 2025-05-29 GMT+08:00

What Are the Application Scenarios of Replication Tables?

Answer: A replication table replicates all data in the table to each DN in the cluster. That is, each DN has a replica. You are advised to use replication tables in the following scenarios:

  • Smaller tables (less than 2 GB), such as dimension data tables in the star structure.
  • Tables that do not frequently insert, update, or delete data.
  • Tables where simple queries are frequently performed. You are advised not to use replication tables for complex queries (conditions include LIKE or NOT LIKE). This complex query calculates each row of the table. In this case, the performance is the best when the calculation is distributed on all nodes. If the table is a replication table, the calculation runs only on one node.