<div>
The trace is showing me what I need. &nbsp;Thanks very much, folks. &nbsp;This is extremely helpful.<br />
<br />
--BrianMc1958
</div>


The trace is showing me what I need.  Thanks very much, folks.  This is extremely helpful.

--BrianMc1958

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
My Java app issues a Java PreparedStatement against an MS SQL 2000 db. &nbsp;I suspect it's actually causing a table scan at a customer site. &nbsp;Is there any way I can retrieve the execution plan after the PreparedStatement exectutes? &nbsp;(The statement would be issued 10,000 times each time my app runs...)<br />
<br />
I know it's not possible through Java. &nbsp;Is it possible through SQL 2000? &nbsp;'m a bit of a dummie about SQL 2000. &nbsp;Is there a setting I can use such that the execution plan(s) would be stored in a SQL log?<br />
<br />
Thanks!<br />
BrianMc1958
</div>
</div>


Dear Experts,

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?

Thanks!
BrianMc1958

Any way to retrieve execution plan after PreparedStatement runs?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.