What are your experiences with smartSQL?
I have seen major improvements in general performance when disabling SmartSQL. NAV is much more responsive and the number of locks is reduced. So far I have not had time to investigate Query plans for when smartSQL is on and off. But it seems like smartSQL is not so smart?