Caro Krützmanncarokruetzi.hashnode.dev·Apr 28, 2024Query Rewrite - My Story of a Performance NightmareA while back, I worked on a project where we shifted data from an old datamodel to a new one. There are lots of interesting aspects and technical details about this project. However, today, I want to discuss a complicated setup of hierarchical Materi...1 like·250 readsmaterialized-views
Harsh Mangeharshmange.hashnode.dev·Apr 16, 2023Boosting Your Database Performance: A Comprehensive Guide to Query Re-Writing for Query OptimizationQuery rewriting is a technique used to optimize database query performance by transforming a complex or inefficient query into an equivalent, more efficient form. This technique involves using rules or algorithms to modify the query structure or exec...38 readsDatabase Query OptimizationDatabases