Depending upon the client and the particulars of processing - simple or extended query protocol - issuing a show plan may not give the relevant plan. For example if you obtain a resultset using the jdbc client and a simple query has been issued, a show plan at the end of processing will actually show some of the under the covers metadata queries.