"=?ISO-8859-1?Q?Alberto_Sim=F5es?=" <[EMAIL PROTECTED]> wrote: > > Consider the following database schema: > CREATE TABLE tetragrams (word1 INTEGER, word2 INTEGER, word3 INTEGER, > word4 INTEGER, occs INTEGER, PRIMARY KEY (word1, word2, word3, > word4)); > CREATE INDEX tet_b ON tetragrams (word2); > CREATE INDEX tet_c ON tetragrams (word3); > CREATE INDEX tet_d ON tetragrams (word4); > > The problem is that I want to use: > > SELECT * FROM tetragrams WHERE word1=6 ORDER BY occs DESC LIMIT 10; > > and it takes.. five minutes and did not give the result yet... > > Is there anything I can do to make it speed up CONSIDERABLY?
CREATE INDEX tet_e ON tetragrams(word1, occs); -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------