'how to fix loading time of query
Software = SQL Developer
I have a complex query with about 250 lines of code with multi nested queries. It make sense this query would take a lot time to load. about 30 secs
My solution to fix the loading time was by creating a view inside a new database & load the dataset in it. So now rather than running long/complex query every time, I can just use view to pull data by using a simple select * from viewQuery;.
issue with the view: outputs is about 180 records, so it shouldn't be taking 25 secs to load it
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|