tober 2019 16:57
To: Yavuz Selim Sertoğlu (ETIYA)
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Query slows when used with view
=?iso-8859-9?Q?Yavuz_Selim_Serto=F0lu_=28ETIYA=29?=
writes:
> I have a problem with views. When I use view in my query it really slows
> down(1.7seconds)
prod_char_val.char_id = gnl_char.char_id
and prod_char_val.char_val_id = gnl_char_val.char_val_id
and prod_char_val.st_id = charvalstatus.gnl_st_id
and (charvalstatus.shrt_code::text = any (array['ACTV'::character
varying::text,
'PNDG'::chara
