Tags » Database Tuning

Reading AWR Report - Part 1

Once in a while I get requests for some information about reading and analyzing an AWR report. I have been thinking for a long time about writing such a post, but always postponed it as it is a very tricky topic. 822 more words


Machine learning for database tuning: Mobiliar’s journey continues. Next stop Munich.

During the first week in May, I could share Mobiliar’s experience with the practical use of machine learning technology for DB2 systems tuning at IDUG’s annual North American DB2 Technical conference in Anaheim, CA. 529 more words


Optimizer Bugs and Issues

I wrote before about optimizer changes after upgrades, so this is a quick post about some more information related to this topic. 213 more words

Database Tuning

Scanning an Index

The internet is full of information about indexes, and for a reason. Indexes in a database is probably the most important performance related topic. There are so many cases, properties, and different ways to use indexes that there is simply a lot to write about. 1,419 more words

Database Development

05 Simple Tuning Rules

Select Consideration

select * from sales_history


Select s.order_ID, s.product_ID, s.price, s.product_name

from sales_order s

The simplest rule is to select only the data you need… 292 more words


Indexing Tool : Database Engine Tuning Advisor

Related article : Indexing Tools for Microsoft SQL Server (You might want to read the article before this one to get a better picture)

The other indexing tool available in… 4,609 more words


Indexing Tool : Missing Index Dynamic Management Objects (DMO)

Indexing Tools

When it comes to indexing, Microsoft has two tools built into SQL Server that can be used to help identify indexes that can improve database performance. 3,074 more words