main_trunk | A repository that can act as our central hub , for others | Game Engine library
kandi X-RAY | main_trunk Summary
kandi X-RAY | main_trunk Summary
A repository that can act as our central hub, for others to fork off of etc.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of main_trunk
main_trunk Key Features
main_trunk Examples and Code Snippets
Community Discussions
Trending Discussions on main_trunk
QUESTION
I want to improve the performance of a query. The query perfomance may be degraded because of the usage of listagg and regxp_like. Is there any other better option in place of these two FUNCTIONS which might improve the performance.
- I'm not allowed to introduce any indexes to the tables I'm using.(There are more indexes added for all the tables... can not add any more)
- Need to tweak around the query approach to improve its performance
Query: Version 2 (Performance 64.796)
...ANSWER
Answered 2017-Jun-13 at 19:15Run it through the SQL Tuning Advisor (if licensed).
Also, in cases where the outer join is just a look-up, you can eliminate an outer join by using a select statement in the select list (which sometimes provides for performance improvements).
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install main_trunk
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page