I have created a custom indexer in my project and configured it to work on '
Update on Schedule'. It is working fine but I have observed, it is executed multiple times even if there is no change in the products. I will explain it through example.
So, I have updated some products and their entries are made in changelog table
version_id. Then when the indexer executed by schedule, it executed successfully and the latest
version_id is updated in the
mview_state table. After this execution also it is executed multiple times even there is no new entry in the changelog table.