On Tue, Jan 9, 2018 at 3:32 PM, Reddygari, Pavan wrote:
>
> A view got converted to postgresql, performance while querying the view in
> postgresql is 10X longer compared to oracle.
>
>FROM (item_attribute_value a
> JOIN item_attribute ON ((a.iav_iat_id = item_attribute.iat_id)))
> WHE
Pavan Reddygari wrote:
> A view got converted to postgresql, performance while querying the view in
> postgresql is 10X longer compared to oracle.
> Hardware resources are matching between oracle and postgresql.
>
> V_item_attributes view code as below, same in oracle and postgresql.
> -
