4 ms·
> This suggester isn’t very good. It takes a single query and suggests indexes for it. The underlying API can analyse multiple queries - looks like they've onl
by zimpenfish 4y ago
> This suggester isn’t very good. It takes a single query and suggests indexes for it.
The underlying API can analyse multiple queries - looks like they've only coded up the test `.expert` command for one.
From [1], "The sqlite3expert object is configured with one or more SQL statements by making one or more calls to sqlite3_expert_sql(). Each call may specify a single SQL statement, or multiple statements separated by semi-colons." then "sqlite3_expert_analyze() is called to run the analysis."
[1] https://www.sqlite.org/src/dir?ci=trunk&name=ext/expert https://www.sqlite.org/src/dir?ci=trunk&name=ext/expert