|
|
|
|
|
|
by zimpenfish
1446 days 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 |
|
|