CREATE TABLE [MyTable] (
  [MyTableID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
  [Sub] INTEGER CONSTRAINT [FK_MyTable_Sub] REFERENCES [MyTable]([MyTableID]) ON DELETE RESTRICT ON UPDATE RESTRICT MATCH FULL DEFERRABLE INITIALLY DEFERRED, 
  [MyTableName] TEXT(256) NOT NULL
)

CREATE INDEX [IDX_MyTable_Sub] ON [MyTable] ([Sub]);

EXPLAIN QUERY PLAN
SELECT *
FROM  [MyTable] AS [T1], [MyTable] AS [T2]
WHERE [T1].[MyTableID]=[T2].[Sub]

SCAN TABLE Table AS T2
SEARCH TABLE DirServiceNomens AS T1 USING INTEGER PRIMARY KEY (rowid=?)

EXPLAIN QUERY PLAN
SELECT * 
FROM MyTable
WHERE Sub=50

SEARCH TABLE MyTable USING INDEX IDX_MyTable_Sub (Sub=?)