Just to better understand, the index on (x,y,z), would
it be useful for queries like
select * from table1 inner join table2
on table1.x=table2.x and table1.y = table2.y and
table1.z=table2.z
or
"table1.y = table2.y and table1.z=table2.z" would not
benefit the index (so it would be better 3 different
indexes) because it is useful just for "field x"
comparison or to retrieve y and z values given x?
Thanks
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
