If this check box is on QAD Data Warehouse Designer will tell SQL Server to use tempdb to store intermediate sort results when creating or rebuilding the index. If this check box is off, QAD Data Warehouse Designer does not tell SQL Server to use tempdb (so SQL Server uses the filegroup the index resides in). The default is off.