Re: [sqlite] Explain Query Plan with virtual tables involved

2014-02-18 Thread Hick Gunter
nique Devienne [mailto:ddevie...@gmail.com] Gesendet: Montag, 17. Februar 2014 11:41 An: General Discussion of SQLite Database Betreff: [sqlite] Explain Query Plan with virtual tables involved Would it be possible to have plans for virtual tables more in line with plans for regular tables?

[sqlite] Explain Query Plan with virtual tables involved

2014-02-17 Thread Dominique Devienne
Would it be possible to have plans for virtual tables more in line with plans for regular tables? With virtual tables, the plan is always a SCAN TABLE, while for regular tables it's either a SCAN TABLE for full scans, and a SEARCH TABLE for an indexed plan. Because I don't yet use idxStr but