Re: Query runtime is slow in view

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

That's exactly what I have explained in the above-mentioned blog post

https://hourim.wordpress.com/2019/12/18/scalar-subquery-caching-the-select-from-dual-trick/

Best regards
Mohamed

Le jeu. 4 févr. 2021 à 00:27, Sayan Malakshinov <xt.and.r_at_gmail.com> a écrit :

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

-- 

Houri Mohamed

Oracle DBA-Developer-Performance & Tuning

Visit My         - Blog <http://www.hourim.wordpress.com/>

Let's Connect -
<http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*

My Twitter <https://twitter.com/MohamedHouri>      - MohamedHouri
<https://twitter.com/MohamedHouri>

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