Hi all,
we are facing some Problems with Queries joining several FTS-Tables.
There seems to be no equivalent to the ANALYZE Command for FTS-Indexes
so they do not contain statistical info for the Query Planner. This
sometimes leads to execution Plans with poor Performance. Some of them
run 20 times slower than their hand-optimized counterpart.
Is there any means to obtain statistical info from an FTS Index so we
can do some reordering by hand? Or some way to provide hints to the
Query Planner like ANALYZE does for regular Table Indexes?
Thanks
Gerd
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users