Home Forums SQL Server 2005 T-SQL (SS2K5) Is it a proper indexing method for boosting performance? RE: Is it a proper indexing method for boosting performance?
Florian Reischl
SSC-Dedicated
Points: 37301
More actions
May 7, 2009 at 3:21 pm
#990724
Hi
It depends on your select statements. If you are selecting by your "Article" column you should reconsider if it really needs NVARCHAR(1000) because this exceeds the maximal key length.
Greets
Flo