There's an index on name since it's unique (as stated here http://www.sqlite.org/lang_createtable.html), however I'm sure there isn't any reason for us to care about this level of optimization. If we were dealing with thousands of rows, then maybe.