I’m having a trouble with my SQL Server DB. Basically, I broke up the relationships (it’s a long history). After I did that, the DB queries (for example SELECT …) takes around 10 sec (I see them in the Ignition Gateway Console), before break the relationships the queries executes fast (around 2 or less).
Even I’ve created the relationships, but I can’t repair the response time of the query. I see the ‘Query Execution Plan’ and a 'Clusted Index Scan takes 75% of the query cost.
Any suggestion for get better performance?