Query Performance - Reg
A query is built on Multiprovider. Earlier it was taking only 1 minute for execution.
Recently around 2000 new products added into master data. From then onwards the query is taking around 6 minutes of time.
What might be the problem?
the records are added in master only.