select distinct
art_id,
art_article_nr,
COALESCE(art_tex.tex_text, art_tex_uni.tex_text) articledes,
ga_id,
ga_tex.tex_text gades,
ga_tex.tex_text||' ('||ga_assembly_tex.tex_text||')' ga_assembly,
la_id,
lat_sort sort,
lat_sup_id bra_id,
COALESCE(sup_cou.sup_brand, sup_null.sup_brand) bra_b
I believe it is Superserver (how can I say exactly?) 2.5.2 64 bit on win7 64
bit.
Cache setings for database are at the moment Pages 16384 = 65536 KB, I tried
different aproaches, with smaller and bigger pages - but I didnt resolve issue.
Regards,
Zoran