• For clarification you can index views but only the Enterprise, Developer, and Evaluation versons of SS2K support them. You can how ever create them in all versions of SS2K for migration from one edition to another,  but the query optimiser will not use the index in Standard and Personal versions of SS2K.

    I don't know if SS2005 changed this though.

    Imagination is more important than knowledge.

    – Albert Einstein