• Actually, Indexed Views ARE available in the Standard edition of SQL Server. You just have to manage them yourself, using explicit query hints.

    From http://msdn.microsoft.com/en-us/library/ms187864.aspx:

    "Indexed views can be created in any edition of SQL Server 2008. In SQL Server 2008 Enterprise, the query optimizer automatically considers the indexed view. To use an indexed view in all other editions, the NOEXPAND table hint must be used."

    Kevin

    --
    Please upgrade to .sig 2.0