• Oops, didn't know I have to use NOEXPAND to use Indexed Views

    all this time I thought when I selected on my view, it used the Clustered Index

    Good thing it wasn't slowing anything down

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005