Changes between Version 7 and Version 8 of otherdevelopment


Ignore:
Timestamp:
05/11/26 13:20:28 (2 weeks ago)
Author:
233062
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • otherdevelopment

    v7 v8  
    6969Избегнува full table scan за годишен филтер
    7070
    71 3.
    72 
    73 {{{
    74 -- FIX: removed duplicate definition (was listed as both #3 and #5 with identical columns)
    75 -- FIX: removed redundant CREATE UNIQUE INDEX users_pkey (primary key index already exists from schema DDL)
    76 CREATE INDEX idx_incomes_covering ON incomes(user_id, date, amount);
    77 }}}
    78 
    79 Подобрување:
    80 Index-only scan (без пристап до табелата) — ги покрива user_id (GROUP BY), date (WHERE year filter) и amount (SUM)
    8171
    8272== SQL за анализа на брзината ==