jeudi 5 février 2015

What is faster in Sqlite?

a is a table index, b is a normal column.



select a,b from ( select a,b from table where a in (*listA*) ) where b in (*listB*)


or



select i,j from table where (a=listA[0] and b=listB[0]) or (a=listA[1] and b=listB[1])...


I am using pseudocode to represent a list declaration.


Aucun commentaire:

Enregistrer un commentaire