The following table lists the unsupported options in detail for Database Engine Tuning Advisor.
| Option | SQL Server 2008 Standard edition | SQL Server 2005 and SQL Server 2000 Standard editions | SQL Server 2000 Enterprise, Developer, and Enterprise Evaluation editions |
| Indexes and indexed views 1 | Not supported | Not supported | Supported |
| Indexed views 1 | Not supported | Not supported | Supported |
| Include filtered indexes 2 | Supported | Not supported | Not supported |
| Full partitioning | Not supported | Not supported | Not supported |
| Aligned partitioning | Not supported | Not supported | Not supported |
| Keep aligned partitioning | Not supported | Not supported | Not supported |
| Generate online recommendations where possible | Not supported | Not supported | Not supported |
| Generate only online recommendations | Not supported | Not supported | Not supported |
1 These options are disabled in the user interface.
2 Filtered indexes are not supported on any edition before SQL Server 2008.
