On Friday, 6 December, 2019 08:17, radovan5 <radovan.antl...@siol.net> wrote:
>ANALYZE dosn't help because data is loaded from RDBMS >for processing every time. From this I take is that you are loading the data from somewhere else and then running this one query and you do not want to run ANALYZE. If that is the case then simply frame the query better. Replace the word "left" with the word "cross" and get rid of the superfluous "and R.ID_ARHDAJ is not null". -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
