What is the maximum number of indexes per table for SQLite? (on Windows XP if that c开发者_如何学JAVAhanges anything!)
I found this when I searched "sqlite indexes". I use Google; it's a pretty good search engine.
There are no arbitrary limits on the number of indices that can be attached to a single table. The number of columns in an index is limited to the value set by sqlite3_limit(SQLITE_LIMIT_COLUMN,...).
精彩评论