Hi, I would like to know is it ok to create indexes on CDC system tables ?
Is there any recommendation from microsoft regarding the same ?
I would like to know will there any performance issues post creating indexes on CDC system tables?
Hi, I would like to know is it ok to create indexes on CDC system tables ?
Is there any recommendation from microsoft regarding the same ?
I would like to know will there any performance issues post creating indexes on CDC system tables?
Hi rahulG-7170,
Welcome to Microsoft Q&A.
According to my test, we can create non-clustered index on the cdc.<capture_instance>_CT table.


But it is not recommended to query system tables directly. Instead, execute the cdc.fn_cdc_get_all_changes_<capture_instance> and cdc.fn_cdc_get_net_changes_<capture_instance> functions. Please refer to this doc. So I think it is better not to create index on the CDC system index.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
15 people are following this question.