SQL Server Performance

Index on views

Discussion in 'General Developer Questions' started by lara99, Aug 4, 2008.

  1. lara99 New Member

    Hi all, I have a question about view, we have views created on some very large table,I wan to ask whether we can create indexes on the view now, as the fact is views have been created for 2 yrs now.
    please post is this really possible.
    Thanks in advance.
  2. satya Moderator

    What is the edition of SQL you are using?
  3. lara99 New Member

    hi satya i am using sql 2000 Enterprise Edition with sp3
    Thanks,
  4. FrankKalis Moderator

    You can create indices on views in any edition of SQL Server 2000. The difference is just that Enterprise Edition automatically takes such views into consideration when generating the execution plan, while other editions have to use the NOEXPAND hint.

Share This Page