Can anyone tell me why the detail column sometime states ‘USING INDEX ....’ and other time ‘USING COVERING INDEX ...’?
At first I thought USING COVERING INDEX implied the search was searching only the first m columns of an n column index (m less than n) but I’ve also seen USING COVERING INDEX when the query was searching all of the columns in the index. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users