Automatic Indexer for SurrealDB

[ansarizafar]

It would be great If SurrealDB has an automatic indexer. We can consider the same approach which is used by Dexter https://ankane.org/introducing-dexter or the approach used by SQLLite

Automatic Indexing
https://www.sqlite.org/optoverview.html#autoindex
Index Recommendations (SQLite Expert)
https://www.sqlite.org/cli.html#index_recommendations_sqlite_expert_

Relevant discussions on Discord https://discord.com/channels/902568124350599239/970336107206176768/1005045362899288129

[ansarizafar]

Cockroachdb EXPLAIN statement automatically recommend required indexes https://www.cockroachlabs.com/docs/stable/explain.html