Query Optimization
5 items tagged with "query-optimization"
Anti-Patterns3
SELECT * Everywhere
Querying all columns by default instead of naming the ones you need, wasting I/O and creating brittle coupling to schema order and shape.
Missing Indexes
Querying large tables with no supporting index, forcing full scans that work in testing and collapse under production data volume.
Index Overuse
Adding an index for every column just in case, bloating storage and slowing every write while most indexes are never used by the planner.
FAQs2
What is a database index and why does it matter?
An index is a separate data structure, usually a B-tree, that lets the database find rows matching a query without scanning the entire table. It drama...
What is a materialized view?
A materialized view is a database object that stores the precomputed result of a query physically on disk, unlike a regular view which runs its query ...