Using DTA to tune queries with placeholders

microsoft.public.sqlserver.tools

19 Jun 2006 2:14 PM

trud

Hi All
I have a plenty of queries, whitch look like these:

SELECT A.USERS,A.RECID FROM RUNTABLE A WHERE RUNID=?

Instead of actual parameter value they have a '?' sign

Is there any possibility to tune such queries in Database Tuning Advisor
Engine? or to display an execution plan?

19 Jun 2006 7:38 PM

manojas

DTA relies on a valid plan from the server.If the server doesnt return
any plan for your statement in question, then DTA cannot tune it
HTH
Manoj

trud wrote:
Show quote

> Hi All
> I have a plenty of queries, whitch look like these:
>
> SELECT A.USERS,A.RECID FROM RUNTABLE A WHERE RUNID=?
>
> Instead of actual parameter value they have a '?' sign
>
> Is there any possibility to tune such queries in Database Tuning Advisor
> Engine? or to display an execution plan?