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

[zzsober]

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 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