Hello!

On Friday 09 April 2010 01:28:18 Jay A. Kreibich wrote:
>   Exactly like every other query the database makes?  Why would
>   this be different?

Virtual table _doesn't_ use any index but query planner show this:
0|2|TABLE role_fts VIRTUAL TABLE INDEX 0:

Why planner don't show full-teable scan as "TABLE role_fts VIRTUAL TABLE"?

Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to