report rendering very slow on varchar(max) column

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