Skip to main content
A
aravind.s
January 16, 2025
Question

Does Sync Records have any impact on DB indexes and Partitions

  • January 16, 2025
  • 2 replies
  • 0 views

Question : we have a employee table , we applied the partitions and indexes on the table to certain field. But the employee table is sync able record type , will the partition and indexes really gonna make any impact when i execute Query record on it  ?


2 replies

mathieud0001
mathieud0001
January 16, 2025

docs.appian.com/.../appian-cloud-database-administration.html

Appian does recommend partitioning for large tables but I would assume it only makes an impact when synching the Record. I doubt that indexes change anything unless you use QueryEntity.

Perhaps [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05] knows more.

peter.lewis
peter.lewis
Employee
January 16, 2025

Yes if you're using synced record types, the indexes on the source table won't have an impact on query performance because Appian performs its own optimizations on data that is synced. Where it could have impact is either in the performance of the sync (because those queries go against the source) or other places that do direct queries like Mathieu suggested.

Terms & ConditionsAccessibility statement