Hi, Yes, You are right. How SQLite will know the position of the row 990 unless it ordered by indexed field.
That takes me to another point, How SQLite exactly interpret the query, I read in the documentation "After the parser assembles tokens into complete SQL statements, it calls the code generator to produce virtual machine code that will do the work that the SQL statements request", And in another part "The program generated by the code generator is executed by the virtual machine" So, I have two questions about that mechanism of executing the quires: - What is the language type that's the code generator is generating? - Can i skip the SQL parsing and provide ready compiled statement to be executed by the VM and tells SQLite what exactly to do, Not what the generator understands from my SQL.? I know if it possible writing pre-compiled quires may cause compatiblity problems with the SQLite future releases but please let me know if it possible. Thanks, Mina.