Breaking News: Grepper is joining You.com. Read the official announcement!

sqlite don't use index

Danila answered on June 6, 2022 Popularity 1/10 Helpfulness 1/10

answer sqlite don't use index

sqlite don't use index

Comment

sqlite> CREATE TABLE foo(bar);
sqlite> CREATE INDEX foo_idx ON foo(bar);
sqlite> EXPLAIN QUERY PLAN SELECT * FROM foo WHERE bar = ?;
QUERY PLAN
SEARCH TABLE foo USING COVERING INDEX foo_idx (bar=?)
 
-- ignore index using NOT INDEXED                                                
sqlite> EXPLAIN QUERY PLAN SELECT * FROM foo NOT INDEXED WHERE bar = ?;
QUERY PLAN
SCAN TABLE foo

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: ignore sql sqlite

Link to this answer
Share Copy Link