Post reply

database engine tuning advisor

  • May 3, 2009 at 3:01 pm

    #204263

    Hi, Im trying to use advisor for performance, its only for testing.

    I cant select in option index and indexed views in section Physical Design Structures to use in database its disabled .

    Any ideas? ..

    thanks Radek

  • May 4, 2009 at 9:45 am

    #988165

    Indexed Views are only in Enterprise Edition.

    Tim White

  • May 4, 2009 at 9:53 am

    #988170

    Not technically correct:

    From: http://technet.microsoft.com/en-us/library/cc917715.aspx

    Note: Indexed views are a feature of all versions of SQL Server 2000 and 2005. In the Developer and Enterprise editions of SQL Server 2000 and 2005, the query processor can use an indexed view to solve queries that structurally match the view, even if they don't refer to the view by name. In other versions, you must reference the view by name and use the NOEXPAND hint on the view reference to query the contents of an indexed view.

    When I bring up DTA on an EE edition, these are not greyed out.

    Tim White

  • May 4, 2009 at 10:13 am

    #988179

    Yes , I know that I must use Hint No expand and create view WITH SCHEMABINDING. So then i dont know why index view is disabled in options in database engine tunning..

    thanks Radek

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply