BohwaZMar 1

I am always amazed by the expert mode of the SQLite CLI.

You type .expert
Then you paste your SQL query.
And #sqlite tells you which indexes you should create to speed up your query.

No AI, no complex program to install. No expensive database architect to pay for. It's just clever programming.

To my knowledge this is the only database in the world to have this feature.

https://sqlite.org/cli.html#index_recommendations_sqlite_expert_
https://sqlite.org/src/dir?ci=trunk&name=ext/expert

Command Line Shell For SQLite

Show threadBarnibuMar 2
@bohwaz SQL Server has it too: https://learn.microsoft.com/en-us/sql/relational-databases/indexes/tune-nonclustered-missing-index-suggestions
Show threadgrawityMar 5
@barnibu @bohwaz I remember seeing this style of diagram in StackOverflow's "public data" website (where you can do direct SQL queries), was wondering how it was generated...
Show threadBarnibu
@grawity @bohwaz yep, they're using SQL Server too and that graphic is rendered from an xml file that SQL Server returns if prompted via `set statistics xml on;`
Mar 5 at 12:11pmWeb