Hi , just to give you other info here is the output of the explain command
C:\sviluppo\sqlite>sqlite.exe ex2 SQLite version 2.8.15 Enter ".help" for instructions sqlite> explain select parole.id,mega.id from parole JOIN mega ON mega.word=parole.word; 0|ColumnName|0|0|parole.id 1|ColumnName|1|1|mega.id 2|ColumnName|2|0|integer 3|ColumnName|3|0|integer 4|Integer|0|0| 5|OpenRead|0|4|parole 6|VerifyCookie|0|781| 7|Integer|0|0| 8|OpenRead|1|325183|Mega 9|Integer|0|0| 10|OpenRead|2|618165|word_idx 11|Rewind|0|30| 12|Column|0|2| 13|NotNull|-1|16| 14|Pop|1|0| 15|Goto|0|29| 16|MakeKey|1|0|t 17|MemStore|0|0| 18|MoveTo|2|29| 19|MemLoad|0|0| 20|IdxGT|2|29| 21|RowKey|2|0| 22|IdxIsNull|1|28| 23|IdxRecno|2|0| 24|MoveTo|1|0| 25|Column|0|0| 26|Column|1|0| 27|Callback|2|0| 28|Next|2|19| 29|Next|0|12| 30|Close|0|0| 31|Close|1|0| 32|Close|2|0| 33|Halt|0|0| sqlite> IN this trace seems to me that only the first index is opened and not the second. Is this correct? Thank a lot alex > select parole.id, mega.id from parole JOIN mega ON mega.word=parole.word; > > Please, post the table schema and some sample data (so we are able to > make tests quickly). > > Paolo > >
