I've problem with SQLite autoindex in UNIQUE table. I've create table like below.
c.execute('''CREATE TABLE social(
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL UNIQUE,
    tampil INTEGER NOT NULL
    );'''
)
c.execute('CREATE INDEX medp on social(name);')
But when I check using explain query plan, SQLite use the autoindex provide by itself. How to avoid this to use my own index instead of it's auto index? How I try:
c.execute('EXPLAIN QUERY PLAN SELECT id FROM social WHERE name = "facebook"')
And the resut is:
(0, 0, 0, 'SEARCH TABLE social USING INDEX sqlite_autoindex_social_1(name=?))
Thank you before.
Aucun commentaire:
Enregistrer un commentaire