My Java app issues a Java PreparedStatement against an MS SQL 2000 db. I suspect it's actually causing a table scan at a customer site. Is there any way I can retrieve the execution plan after the PreparedStatement exectutes? (The statement would be issued 10,000 times each time my app runs...)
I know it's not possible through Java. Is it possible through SQL 2000? 'm a bit of a dummie about SQL 2000. Is there a setting I can use such that the execution plan(s) would be stored in a SQL log?