## Summary **No review yet** ## Minimized query ```sql PRAGMA query_only = 0; PRAGMA encoding = 'UTF-16be'; PRAGMA auto_vacuum = NONE; .timer on CREATE TABLE t1(a,b INT); INSERT INTO t1(a,b) VALUES(1,2),(3,3),(4,5); CREATE UNIQUE INDEX i1 ON t1(b,b,a,a,a,a,a,b,a); ANALYZE; DROP TABLE IF EXISTS sqlite_stat4; INSERT INTO sqlite_stat1 VALUES('t1','i1','30 30 30 2 2 2 2 2 2 2'); ANALYZE sqlite_master; PRAGMA checkpoint_fullsync = NO; ``` ## Actual output ```sql Run Time: real 0.000 user 0.000094 sys 0.000000 Run Time: real 0.000 user 0.000019 sys 0.000000 Run Time: real 0.000 user 0.000071 sys 0.000000 Run Time: real 0.000 user 0.000074 sys 0.000000 Run Time: real 0.000 user 0.000005 sys 0.000000 Run Time: real 0.000 user 0.000008 sys 0.000000 Run Time: real 0.000 user 0.000020 sys 0.000000 Run Time: real 0.000 user 0.000003 sys 0.000000 ``` ## Expectation ```sql Run Time: real 0.000066 user 0.000081 sys 0.000000 Run Time: real 0.000018 user 0.000019 sys 0.000000 Run Time: real 0.000058 user 0.000060 sys 0.000000 Run Time: real 0.000067 user 0.000067 sys 0.000000 Run Time: real 0.000004 user 0.000005 sys 0.000000 Run Time: real 0.000006 user 0.000007 sys 0.000000 Run Time: real 0.000018 user 0.000018 sys 0.000000 Run Time: real 0.000002 user 0.000002 sys 0.000000 ``` ## Flag ``` ```