Re: Query runtime is slow in view

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Thu, 4 Feb 2021 02:26:53 +0300
Message-ID: <CAOVevU6jxicrk+AmBcv9Kc9FvKk62TsbOUzBhMB-Y-gSuz977A_at_mail.gmail.com>

or you can just wrap it into scalar subquery ... = (select fnd_profile.value('ORG_ID') from dual)
for scalar subquery caching

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 04 2021 - 00:26:53 CET

This message: [ Message body ]
Next message: Noveljic Nenad: "RE: registering non-RAC databases and listeners in Clusterware"
Previous message: Amit Saroha: "Re: Query runtime is slow in view"
In reply to: Amit Saroha: "Re: Query runtime is slow in view"
Next in thread: Mohamed Houri: "Re: Query runtime is slow in view"
Reply: Mohamed Houri: "Re: Query runtime is slow in view"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message