• I would use AND INDEX_ID <= 1 when index space is not needed.

    Index ID 0 is for heap tables and Index ID 1 is for tables with clustered index.

    ----------------------------------------------------------------------------------------------
    Microsoft Certified Solution Master: Data Platform, Microsoft Certified Trainer
    Email: Louis.Li@rrlminc.com | Blog[/url] | LinkedIn[/url]