Hello All,
I've found that SQLite-3.5.4 doesnt use index in this situation:

sqlite> create table t1 (id int primary key, val int);
sqlite> create table t2 (id unique, val int primary key);
sqlite> explain query plan update t1 set val = (select t2.val from t2
where t1.id = t2.id);
0|0|TABLE t1
0|0|TABLE t2

In this case, SQLite should takes value from t2 via unique id INDEX,
but it doesn't


-- 
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to