Indexing is a critical part of database optimization. Indexing can dramatically increase query speed. However, DBAs still struggle with finding optimal indexes or optimal SQL plans. DBTA held a ...

Well, I used it in MySQL, and I'm guessing it's similar for DB2. It's a very handy command that allows you to see the way the database system is performing a query, in terms of the indexes it's ...