SQL Indexing Beyond Simple Columns: Expressions, Text Fragments, Attributes J...
summary
Shows concrete SQL indexing techniques beyond simple columns: create expression indexes (e.g., trunc(date_delivery - date_order) for same‑day deliveries), use sorted keys to serve Top‑10 queries without a full sort, build reverse(name) indexes to enable suffix searches, and use GIN trigram indexes for substring matching. Demonstrates indexing JSON/JSONB attributes with GIN, compares Postgres vs Yugabyte behavior for index‑only scans/visibility, and validates index choices by inspecting execution plans.
AI-written summary · about
chapters (6)
- 0:00SQL indexing introduction
- 10:10Partial indexes optimization
- 20:28Covering indexes included columns
- 30:23Indexes on expressions functions
- 40:16Top N queries pagination
- 44:53Conclusion Q&A
related talks
51mSQL indexing: expressions, text fragments, JSON attributes and Top-N queries
01h 00mFlexible Indexing With Postgres
53mAdvanced Indexing Techniques in PostgreSQL
46mA Deep Dive Into PostgreSQL Indexing
37mRules of Indexing in PostgreSQL
49mFlexible Indexing with Postgres
52mA Deep Dive into PostgreSQL Indexing
37mRules of Indexing in PostgreSQL