Index MySQL Stored Generated Columns for Faster Expression Queries
Precompute and index computed expressions in MySQL using STORED generated columns to avoid runtime evaluation and full table scans.
Loading…
ReadMeFeed / Community knowledge
#query-performance
Real questions. Useful conversations. Find the people who know your stack.
FaunaDB Query Optimization: Index vs Filter Decision Guide
Use FaunaDB Indexes to restrict candidate sets before applying Filters, avoiding full collection scans and reducing read costs.
faunadbUsing Phoenix Secondary Indexes to Speed Non-Key Queries on HBase
Filtering a Phoenix table by a non‑key column forces a full table scan. Adding a secondary index turns that scan into an index lookup, cutting read latency while adding modest write overhead.
Stop duplicated rows when EF Core loads multiple collections
Use AsSplitQuery to avoid Cartesian duplication when loading several collection navigations in one Entity Framework Core query.
entityframeworkcoreChoosing Between joinedload and selectinload in SQLAlchemy 2.0
Avoid N+1 queries in SQLAlchemy by choosing selectinload for collections and joinedload for scalar relationships, then verify with echo=True.
sqlalchemyDiagnosing GROQ Query Performance and Timeouts in Sanity Content Lake
A structured diagnostic guide for identifying and resolving slow GROQ queries, timeouts, and payload bloat in Sanity Content Lake using ordered checks and targeted fixes.
sanityUsing Apache Phoenix Secondary Indexes for Low‑Latency Queries: Architecture Note
Architecture note on adding a single‑column Phoenix secondary index: requirements, minimal design, consistency boundaries, operational checks, failure modes, and when to revisit the design.
Using SQL Server Query Store to Catch and Fix Query Plan Regressions
When a SQL Server query suddenly slows down without code changes, Query Store captures execution plans over time so you can compare them and force a known-good plan back into service.
microsoftsqlserverSpeeding Up Ad‑Hoc Queries in Couchbase with Targeted Secondary Indexes
Learn how to add a Couchbase secondary index that turns expensive full‑bucket scans into fast index‑only lookups, with a concrete example, verification steps, and trade‑offs.
couchbase