• in 2005, you don't need an indexed view to get what amounts to a second clustered index on a table - you can get the same effect with included columns (new feature in 2005).

    create a non-clustered index that also includes every non-key column in the table. This will be a copy of the table that's physically stored in key order.

    not sure if anyone mentioned this about included columns already - didn't see it anyway.

    ---------------------------------------
    elsasoft.org