Re: Query Tunning related to function

On Sun, Apr 17, 2022 at 8:53 AM Kumar, Mukesh wrote: > We request you to please provide some assistance on below issue and it is > impacting the migration project. > I suggest you try and re-write the loop-based function into a set-oriented view. Specifically, I think doing:

RE: Query Tunning related to function

; MUKESH KUMAR ; heda.giri...@tcs.com Subject: RE: Query Tunning related to function Hi Babu , Please find below the script for the function from Oracle Hi babu , Please find attached the script for function from Oracle . Please revert in case of any query. Thanks and Regards, Mukesh Kumar From

RE: Query Tunning related to function

: Michel SALAIS ; Ranier Vilela ; postgres performance list ; MUKESH KUMAR ; heda.giri...@tcs.com Subject: Re: Query Tunning related to function Can you paste from oracle for Set lines 1 Select text from dba_source Where name = UPPER('translate_payment_status') And owner = 'IMS_APP' Thanks

Re: Query Tunning related to function

On Thu, Apr 14, 2022 at 06:03:33AM +, Kumar, Mukesh wrote: > We are running the below query in PostgreSQL and its taking approx. 8 to 9 > sec to run the query. > > Query - 1 ... > > The explain plan and other details are placed at below link for more > information. We have checked the

Re: Query Tunning related to function

ayment_status(payment_sid_c) IN ('PAID', > 'MANUALLYPAID') > > > > And you can also try to write the query like this: > > > > Select t.payment_sid_c, lms_app.translate_payment_status(t.payment_sid_c) > > From > > ( > > Select > > payment_sid_c

RE: Query Tunning related to function

ciated. Thanks and Regards, Mukesh Kumar From: Michel SALAIS Sent: Thursday, April 14, 2022 11:45 PM To: Kumar, Mukesh ; 'Ranier Vilela' Cc: pgsql-performa...@postgresql.org; 'MUKESH KUMAR' Subject: RE: Query Tunning related to function Hi, This part of the function is odd and must be d

RE: Query Tunning related to function

...@postgresql.org; MUKESH KUMAR Objet : RE: Query Tunning related to function Hi Rainer , We tried to create the partial ‘index on table but it did not help, and it is taking approx. 7 sec now. Also we tried to force the query to use the index by enabling the parameter at session

RE: Query Tunning related to function

: Ranier Vilela Sent: Thursday, April 14, 2022 7:56 PM To: Kumar, Mukesh Cc: pgsql-performa...@postgresql.org; MUKESH KUMAR Subject: Re: Query Tunning related to function Em qui., 14 de abr. de 2022 às 08:01, Kumar, Mukesh mailto:mku...@peabodyenergy.com>> escreveu: Hi Team, We are running the

Re: Query Tunning related to function

Em qui., 14 de abr. de 2022 às 08:01, Kumar, Mukesh < mku...@peabodyenergy.com> escreveu: > Hi Team, > > > > We are running the below query in PostgreSQL and its taking approx. 8 to 9 > sec to run the query. > > > > Query – 1 > > > > Select * from > > ( > > Select payment_sid_c, > >

Query Tunning related to function

Hi Team, We are running the below query in PostgreSQL and its taking approx. 8 to 9 sec to run the query. Query - 1 Select * from ( Select payment_sid_c, lms_app.translate_payment_status(payment_sid_c) AS paymentstatus from lms_app.lms_payment_check_request group by payment_sid_c)