Hi I am using SQLite to store bigrams, trigrams and tetragrams. Let's look for one of the tables:
CREATE TABLE trigrams (word1 INTEGER, word2 INTEGER, word3 INTEGER, occs INTEGER, PRIMARY KEY (word1, word2, word3)) My main question is: what's the difference of efficiency between using this index for the compound key, or three different indexes, one for each word? When I ask efficiency, I would like to consider the differences of timings on creating the indexes/inserting data, and the differences of timings on selects by full key. Somebody has timings on this? Kind regards, Alberto -- Alberto Simões ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------