Hello everyone,

I am currently managing a large database with millions of records in MySQL/MsSQL ; and I am facing performance issues with some of my queries. They tend to run slower than expected; especially as the database continues to grow.

I am looking for advice on-
How do I confirm my indexes are efficient?
Are there common practices / tools to identify inefficiencies?
What’s the best way to pinpoint & resolve these?

If anyone has experience dealing with similar challenges / can recommend tools; techniques; or resources; I would be very grateful for your advice !

I have checked https://webmaster.bbs.tr/forumdispla...i-programlama- msbi guide for reference but still need help.


Thanks in advance for your help!