@Kaustav Ghosh (LTIMINDTREE LIMITED) Thanks for your time over offline discussion. I am summarizing our offline conversation and posting it as answer to help other community members.
- Why it not able to retrieve the expected results for most cases even though appropriate data is present?
Customer has investigated and found that, this issue has happened because they are querying using wrong search queries.
- Refresh of the index has to be done automatically when file is uploaded/deleted from the blob.
Azure storage indexer supports change detection mechanism which keep track of the last update using the built-in time stamps on object and it will automatically add the newly added documents.
Although change detection is a given, deletion detection isn't. An indexer doesn't track object deletion in data sources. To avoid having orphan search documents, you can implement a "soft delete" strategy that results in deleting search documents first, with physical deletion in Azure Storage. Refer to this documentation for more information.
Hope this helps, let me know if you have any further questions on this.