Tag Archives: explain

Optimization profiles in DB2 UDB

How many times have we spend hours trying to figure why DB2 is not choosing a particular index and access path ? Probably many !    DB2 is one of the best cost based optimizer out there , but yet … Continue reading

Posted in database, db2, how to | Tagged , , , , , , , , , , , , , , , , , , , , | Leave a comment

Nice to meet you db2batch !

I have been using db2batch for a while now. The more I use it, the more I like it. It can give you very useful information about your query that can help you tune it.  It can give you execution … Continue reading

Posted in db2 | Tagged , , , , , , | Leave a comment