i've had great luck with it. i can't say i'm any sort of database expert, but it's a lot better at this than me.

i was especially impressed that it could not only suggest changes to the queries or indexes to add, but it suggested a query be split into multiple queries at the application level which worked incredibly well.