Hi,
Try to include the columns with varchar(max) data type in a nonclustured index. If there is a where clause in the query that is populating the report then the columns participating in the where clause should make the key of the nonclustured index.
Thanks and Regards Alankar Chakravorty MCITP Database Administrator SQL Server 2008 MCITP Database Administrator SQL Server 2005
No comments:
Post a Comment