-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 04/06/13 08:14, Eleytherios Stamatogiannakis wrote: > We have tried with both views and VTs but SQLite does not create > automatic indexes on them at all. So right now, to be able to have > automatic indexes from SQLite's side we materialize all Virtual Tables > into plain tables:
There is no reason that the virtual table implementation can't create automatic indexes. In response to the xBestIndex calls, the indices don't actually have to exist. You just need to ensure the estimated cost is relatively useful. If SQLite then decides to use the index you can then create it on the fly. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAlGuQQMACgkQmOOfHg372QRxxwCfV1QvfO6Fsky0x3krTLe08+Nm EN4AniM6kkOHgcTm/mtREY3iD4QAF9o+ =KOXn -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
