*** 8,13 **** --- 8,19 ---- SQLite opcodes are considered private and can change from version to version, so be warned, that idxchk may not work correctly for other versions. + _: The opcodes associated with indices changed somewhat with version 3.2.3 + so this utility may well have broken. (I haven't tried it so I do not know + for sure.) But beginning with version 3.2.6, you can use "EXPLAIN QUERY PLAN" + in front of a query to get a description of what indices are being + used. + Run idxchk as:
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|