Post reply

how can we create Index on view?

  • March 18, 2009 at 3:47 am

    #73469

    how can we create Index on view? Plz give me a small example..

  • March 18, 2009 at 3:58 am

    #961673

    CREATE INDEX [NewIndexName] ON [ViewName]([ColumnName])


    Nuke the site from orbit, its the only way to be sure... :w00t:

  • March 18, 2009 at 4:12 am

    #961685

    Keep in mind that Indexed views are only supported in the Enterprise Edition of SQL 2000

    [font="Verdana"]Markus Bohse[/font]

  • March 18, 2009 at 4:36 am

    #961697

    Also note that there's a long list of limitations and restrictions on what may be in an indeed view (check Books Online) and that the first inde created on the view must be UNIQUE CLUSTERED.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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