Assuming the DBMS knows "explain", which is why I had to put in the caveat about the DBMS. I myself come from a Sybase background which requires different commands like "set showplan" to do that kind of thing. And what if it's mysql?