![]() The impact on your users and customers is the same, but because those delays can have different causes, you’ll deal with each one differently.Īnother factor in Oracle query optimization is the role that it plays in your job description. The other is that the query is chewing up too many system resources (memory, CPU, network). One is that too much time elapses between the user’s/customer’s action and the response from the database. The short answer is that you want to modify the query to eliminate the delay in the application and improve database performance.īut there are two different kinds of delay. In this post, I’ll explain a few basic concepts of optimizing queries in Oracle. ![]() All they know is they can’t be productive or buy your products when pages take forever to load and screens seem stuck. Most users and customers won’t know that the problem lies inside an Oracle query, and they don’t care, either. You get voicemail from your boss that starts (and maybe ends) with, “Fix the application.”.The number of abandoned shopping carts on your site suddenly spikes.That comment on Slack (or Yammer or Teams) reading “I’m never going to get my work done if the system stays this slow all day” starts rolling up dozens of likes.The trouble tickets in your queues start to pile up.You may not know when you need Oracle query optimization, but you certainly know when you need improvements in your database performance.
0 Comments
Leave a Reply. |