Hello, I am trying to take advantage of the AMC. We've been using the three Talend logging tables for a while, so they've grown quite large. Can someone tell me which columns on those tables should be indexed to improve performance of the AMC? Thanks, Jesse
Why are you wanting to retain the data "for a while"? What are you trying to accomplish?
If you must retain AMC data, say for long term for historical reporting, then I suggest you roll off data from the Talend database into an archival or analytic database to maintain the runtime performance of you jobs that write to the AMC.
You may find that indexing the AMC will slow your jobs as they now need to maintain the index.
