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 ?
Discussion posts and replies are publicly visible
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 Peter Lewis knows more.
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.