Re: [SQLDownUnder] Quickie Q - Index Tuning Wizard and SQL 2000 functions

[zzsober]

Hi Jason,

 

Thanks for your reply.

 

I'm selecting the specific sql command via Query Analyser as my trace.

 

And I'm using the "Thorough" Tuning mode and in the Advanced options removing the checkbox against the "limit number of workload queries to sample".

 

Is this what you mean by the work balance?

 

Regards,

Scott

 

On 9/5/07, Jason Love <jlove@xxxxxxxx> wrote:

I think it depends on the trace file you feed it and the work balance on that set.

----- Original Message -----
From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx <SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx>
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx < SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Tue Sep 04 18:27:55 2007
Subject: [SQLDownUnder] Quickie Q - Index Tuning Wizard and SQL 2000 functions

Hi guys,

Does the Index Tuning Wizard tune SQL Server 2000 functions?

My findings are that it doesn't....  I log select the statement in Query Analyzer and run the Index Tuning wizard against it and it doesn't recommend any indexes, but when I manually run some of the sql statements inside my function through the Analyzer, it does recommend indexes.

Is this normal, or am I missing a setting somewhere....

The reason I'm using a function is to further filter the results of a stored procedure.  If I didn't use a function, I'd have to maintain the where clause in two locations.  See http://www.stillhq.com/sqldownunder/archives/msg00220.html < http://www.stillhq.com/sqldownunder/archives/msg00220.html>  for the post back in 2005.

Regards,

Scott

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net