Searched refs:ANALYZE (Results 1 – 25 of 90) sorted by relevance
1234
50 ANALYZE56 ANALYZE102 ANALYZE t1;124 ANALYZE t1;168 ANALYZE;205 ANALYZE;217 ANALYZE;249 ANALYZE;304 ANALYZE;360 ANALYZE[all …]
32 ANALYZE;35 ANALYZE sqlite_master;123 ANALYZE sqlite_master;147 ANALYZE;149 ANALYZE sqlite_master;173 ANALYZE;197 ANALYZE;234 ANALYZE;303 ANALYZE;352 ANALYZE;[all …]
52 ANALYZE;87 ANALYZE;123 ANALYZE;148 ANALYZE;292 ANALYZE;308 ANALYZE;338 ANALYZE;350 ANALYZE;357 ANALYZE;364 ANALYZE;[all …]
59 # Without ANALYZE, a skip-scan is not used69 # Now do an ANALYZE. A skip-scan can be used after ANALYZE.72 ANALYZE;78 ANALYZE sqlite_master;105 # skip-scan should not be used after an (unfudged) ANALYZE.116 ANALYZE;130 # skip-scan will be used after an (unfudged) ANALYZE.135 ANALYZE;174 # Now do an ANALYZE. A skip-scan can be used after ANALYZE.177 ANALYZE;[all …]
36 ANALYZE;40 ANALYZE sqlite_master;64 ANALYZE sqlite_master;88 ANALYZE sqlite_master;116 ANALYZE sqlite_master;127 ANALYZE sqlite_master;144 ANALYZE sqlite_master;158 ANALYZE sqlite_master;170 ANALYZE sqlite_master;
13 # implements tests for ANALYZE to verify that multiple rows containing42 ANALYZE;65 ANALYZE;71 # Create a multi-column indices using t1.b and verify that ANALYZE 83 ANALYZE;89 # ANALYZE statistics.112 ANALYZE;
44 ANALYZE47 ANALYZE t150 ANALYZE main53 ANALYZE main.t186 ANALYZE;
124 ANALYZE;136 ANALYZE;146 ANALYZE;156 ANALYZE;165 ANALYZE;174 ANALYZE;183 ANALYZE;293 ANALYZE;350 ANALYZE;
109 ANALYZE;138 ANALYZE;168 ANALYZE;198 ANALYZE;213 ANALYZE;228 ANALYZE;246 ANALYZE;266 ANALYZE;294 ANALYZE;
36 ANALYZE sqlite_schema;38 ANALYZE sqlite_schema;52 ANALYZE sqlite_schema;56 ANALYZE sqlite_schema;
51 ANALYZE;79 # If ANALYZE is run on an empty table, make sure indices are used86 ANALYZE;99 ANALYZE t201;115 ANALYZE t201;
12 # This file implements tests for the ANALYZE command.57 ANALYZE;61 # With full ANALYZE data, SQLite sees that c=150 (5 rows) is better than86 ANALYZE;
376 ANALYZE sqlite_schema;406 ANALYZE;413 ANALYZE sqlite_schema;437 ANALYZE sqlite_schema;439 ANALYZE sqlite_schema;454 ANALYZE sqlite_schema;456 ANALYZE sqlite_schema;485 ANALYZE sqlite_schema;488 ANALYZE sqlite_schema;509 ANALYZE sqlite_master;
35 ANALYZE sqlite_master;38 ANALYZE sqlite_master;62 ANALYZE sqlite_master;72 ANALYZE sqlite_master;
12 # This file implements tests for the ANALYZE command when an idnex19 # There is nothing to test if ANALYZE is disable for this build.53 execsql {ANALYZE t1a;}75 execsql {ANALYZE t1cd;}
80 ANALYZE;92 ANALYZE;102 ANALYZE;112 ANALYZE;121 ANALYZE;130 ANALYZE;139 ANALYZE;163 execsql ANALYZE250 ANALYZE;
271 ANALYZE;298 ANALYZE;346 ANALYZE sqlite_schema;348 ANALYZE sqlite_schema;361 ANALYZE;380 ANALYZE;384 ANALYZE sqlite_schema;411 ANALYZE;
83 # column. ANALYZE the table.110 ANALYZE;201 ANALYZE;253 ANALYZE;385 execsql ANALYZE589 execsql ANALYZE702 execsql ANALYZE722 ANALYZE;732 ANALYZE;736 ANALYZE sqlite_master;
11 # Tests for functionality related to ANALYZE.62 ANALYZE;65 # Now, with the ANALYZE data, the planner knows that (b=44) matches a
18 # making bad assumptions about index cost when data from ANALYZE29 ANALYZE;
34 ANALYZE;86 ANALYZE;143 ANALYZE;195 ANALYZE;
38 execsql ANALYZE102 execsql ANALYZE167 execsql ANALYZE
39 ANALYZE sqlite_master;65 ANALYZE sqlite_master;132 ANALYZE sqlite_master;169 ANALYZE;
34 ANALYZE49 ANALYZE80 ANALYZE;90 ANALYZE;133 ANALYZE;145 ANALYZE179 execsql { ANALYZE }220 ANALYZE;223 ANALYZE;241 ANALYZE;[all …]
79 ANALYZE;199 # First test a query with no ANALYZE data at all. The outer loop is210 # Now create enough ANALYZE data to tell SQLite that virtual table "rt"214 ANALYZE;227 # Delete the ANALYZE data. "t1" should be the outer loop again.240 # This time create and attach a database that contains ANALYZE data for249 ANALYZE;276 ANALYZE;