Hi Tom,
Thanks for the hints..
I made various tests for index
The best I could get is the following one with
create index vat_funcvaratt_multi_idx on
functionalvarattributes(split_part(split_part(attvalue,' ',1),'.',1), tag_id,
atttype_id);
analyze functionalvarattributes;
explain analyze sele
El 26/07/16 a las 06:01, Abadie Lana escribió:
> Hi Tom,
> Thanks for the hints..
>
> I made various tests for index
> The best I could get is the following one with
> create index vat_funcvaratt_multi_idx on
> functionalvarattributes(split_part(split_part(attvalue,' ',1),'.',1), tag_id,
> attt
Dear Martin
I run an analyse on the whole database + explicit analyse on tables involved in
the query.
Here the result of explain (analyse, buffer). Thanks for your help and let me
know if you need more information.
explain (analyze, buffers) select s.attvalue from functionalvarattributes s,
ta