I found the linked article very helpful to refresh my understanding of database indexes. As a small bonus, it includes a few helpful SQL oneliners like these two:

• Detecting unused indexes Show archive.org snapshot
• Detecting duplicate indexes Show archive.org snapshot

Warning

Do not run random code snippets unless you understand them in detail - especially in production.

UI/UX Design by

We make sure that your target audience has the best possible experience with your digital product. You get:

• Design tailored to your audience
• Proven processes customized to your needs
• An expert team of experienced designers

Read more Show archive.org snapshot