Can I create an index in SQLITE that is only ever used in an 'indexed by'
clause and not automatically picked up the query optimizer?
I have seen a few cases where a newly added index would start showing up
uninvited in old, previously tested queries and bring performance down by an
order of magnitude. ('analyze' doesn't fix it).
The new indexes would only be needed for new queries, so I don't mind forcing
an 'indexed by' in for those, but I would like to avoid retrofitting every
previous query we've ever written with an 'indexed by'.
- Deon
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
