Indexes
2 articles tagged Indexes.
SQL Server Index Fragmentation: When to Rebuild or Reorganize an Index
Measure index fragmentation and page density in SQL Server, then choose ALTER INDEX REORGANIZE, REBUILD or a statistics update, with online and resumable options.
PostgreSQL EXPLAIN ANALYZE: How to Read Query Plans and Fix Slow SQL
Read a PostgreSQL execution plan node by node, compare estimated and actual rows, spot sequential scans, spilling sorts and loops, and choose the right fix.