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 ...

I wanted to get some suggestions for scheduled maintenace on a SQL Server 2000 box that is hosting a relatively small database (<=13GB). I already have a weekly integrity check that reorganizes ...