What is Tuning?

In the context of database processing, tuning can be defined as a set of techniques that helps the database to operate more efficiently–with higher throughput.

Database tuning can be at the SQL statement level, or at the system level.

SQL Tuning

SQL Tuning is a set of techniques used to execute the SQL in the least amount of time using minimal system resources.

This would include :

  • Collecting proper statistics for the database objects
  • Use of bind variables to minimize parsing
  • Creating proper indices and/or partitions
  • Use of Hints
  • Use of SQL Profiles and Baselines
  • Careful use of parallel processing.
  • Logical optimization etc.

Database Tuning

Database tuning involves I/O and memory tuning, adjusting various parameters, techniques to reduce lock/latch contention etc. Also, the underlying OS tuning may be necessary for optimal results.

 

52 thoughts on “What is Tuning?

  1. I discovered your weblog website on google and check just a few of your early posts. Continue to maintain up the superb operate. I simply additional up your RSS feed to my MSN News Reader. Looking for ahead to studying extra from you in a while!…

  2. Great – I should certainly pronounce, impressed with your web site. I had no trouble navigating through all tabs as well as related information ended up being truly simple to do to access. I recently found what I hoped for before you know it at all. Quite unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your client to communicate. Nice task..

  3. Thanks for another informative blog. The place else may I am getting that kind of information written in such an ideal way? I’ve a venture that I am simply now running on, and I’ve been on the glance out for such information.

  4. you are truly a just right webmaster. The web site loading velocity is incredible. It sort of feels that you are doing any distinctive trick. Furthermore, The contents are masterwork. you have performed a magnificent activity in this subject!

  5. I was curious if you ever considered changing the structure of your blog? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or 2 pictures. Maybe you could space it out better?

  6. Have you ever thought about writing an ebook or guest authoring on other blogs? I have a blog based upon on the same subjects you discuss and would love to have you share some stories/information. I know my audience would enjoy your work. If you are even remotely interested, feel free to shoot me an e-mail.

  7. Great – I should certainly pronounce, impressed with your site. I had no trouble navigating through all the tabs as well as related information ended up being truly simple to do to access. I recently found what I hoped for before you know it at all. Quite unusual. Is likely to appreciate it for those who add forums or something, web site theme . a tones way for your client to communicate. Excellent task..

  8. What Is Neotonics? Neotonics is a skin and gut supplement made of 500 million units of probiotics and 9 potent natural ingredients to support optimal gut function and provide healthy skin.

  9. I have read some just right stuff here. Definitely value bookmarking for revisiting. I surprise how a lot attempt you place to create any such great informative site.

  10. A person essentially help to make seriously posts I would state. This is the first time I frequented your web page and thus far? I surprised with the research you made to create this particular publish amazing. Wonderful job!

  11. Hello there! Quick question that’s totally off topic. Do you know how to make your site mobile friendly? My blog looks weird when viewing from my iphone4. I’m trying to find a theme or plugin that might be able to resolve this problem. If you have any suggestions, please share. Cheers!

  12. What Is Java Burn? Java Burn is a natural health supplement that is formulated using clinically backed ingredients that promote healthy weight loss.

  13. Hello my family member! I want to say that this post is amazing, great written and include approximately all vital infos. I would like to see more posts like this .

  14. Hi there, just became aware of your blog through Google, and found that it’s truly informative. I am gonna watch out for brussels. I will be grateful if you continue this in future. A lot of people will be benefited from your writing. Cheers!

  15. I have been exploring for a little bit for any high quality articles or weblog posts in this sort of area . Exploring in Yahoo I eventually stumbled upon this site. Studying this information So i¦m satisfied to express that I have a very just right uncanny feeling I discovered exactly what I needed. I most indubitably will make certain to do not omit this web site and give it a look regularly.

  16. Spot on with this write-up, I really assume this website wants much more consideration. I’ll most likely be again to learn way more, thanks for that info.

  17. It’s a pity you don’t have a donate button! I’d certainly donate to this brilliant blog! I guess for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to fresh updates and will share this website with my Facebook group. Chat soon!

  18. Thank you a lot for providing individuals with remarkably spectacular chance to read from here. It really is very great and as well , jam-packed with a lot of fun for me and my office acquaintances to search your web site not less than 3 times in a week to study the fresh items you will have. Of course, I am also at all times happy for the breathtaking suggestions served by you. Certain 1 facts in this posting are easily the very best we have ever had.

  19. This design is steller! You definitely know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Great job. I really loved what you had to say, and more than that, how you presented it. Too cool!

  20. Awesome blog you have here but I was wondering if you knew of any community forums that cover the same topics talked about in this article? I’d really love to be a part of online community where I can get feedback from other knowledgeable people that share the same interest. If you have any recommendations, please let me know. Thanks a lot!

  21. I have been browsing online greater than 3 hours today, but I never discovered any attention-grabbing article like yours. It’s pretty price sufficient for me. In my view, if all webmasters and bloggers made just right content material as you did, the internet might be much more useful than ever before.

Leave a Reply

Your email address will not be published. Required fields are marked *