Hacker News new | ask | show | jobs
by somurzakov 2029 days ago
rebuilding query plan takes less than 50ms and is routinely done by the engine itself without you ever realizing it.

what you probably wanted to mention is table statistics - but they are cleared only if you truncate your table, but then again - once you populate your table - the engine will recalc statistics by itself.

overall RDBMS does a lot of stuff behind the scenes for you, and you should take advantage of it, and instead think about more important atuff - business logic, data modeling, schema evolution, etc