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] -----------------------------------------------------------------------------
