Need 50% cost savings to suggest index

Question

Need 50% cost savings to suggest index

livingsilver94 opened this issue 6 years ago · 2 comments

Hello,
I have a pretty easy yet slow query I'm trying to speed up. Dexter doesn't find more indexes to help speeding it up and with --log-sql --log-level debug2 it returns "Need 50% cost savings to suggest index". What's the meaning of this?

Answer 1 · 2019-02-26T20:30:17.000Z

Hey @livingsilver94, that means it found an index, but the index didn't provide enough cost savings (based on EXPLAIN) to be recommended.

Answer 2 · 2019-02-26T21:12:00.000Z

Thanks a lot! Definitely helping 😄