Thank you very much! It works well!
Igor Tandetnik wrote: > > Try this: > > select wf1.wordForm > from wform wf1 join mgWordsRelations rel on (wf1.wordNorm = > rel.id_norminrel) > join wform wf2 on (rel.id_norm = wf2.wordNorm) > where wf1.ancode = 'someAncode' and wf2.wordForm = 'someWord' > order by random() limit 1; > > It's the same query, just written in a simpler form that might make it > easier for SQLite to optimize. > > Igor Tandetnik > -- View this message in context: http://old.nabble.com/Help-me-please-to-optimize-sql-query-tp26354687p26358367.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users