Hi Guarav,

In order for a view to be indexed, it must be created with the "With Schema
Binding" option. This prevents the underlying schema from being modified.

Roger

-----Original Message-----
From: Gaurav Kohli
[mailto:mssqldba-ezmlmshield-x80103358.[Email address protected]
Sent: Monday, April 30, 2007 4:49 AM
To: LazyDBA Discussion
Subject: Indexes on Views


Hi Gurus,



I'm trying to create indexes on one of the "Views" that we have in our
database. The database is on SQL Server 2000.



When I open the "View" in "enterprise manager" and Right-click the
background of the Diagram pane, the "Manage Indexes" option appears
disabled.



Any idea about this?



Thanks

Gaurav Kohli



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page