Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning problem creating index on view RE: problem creating index on view

  • June 10, 2009 at 10:13 am

    #1007525

    Naveen Kumar (6/10/2009)

    I have performance issue in my application. This view contains more than 5 lakh records.

    Please help me how to create unique clustered index on this view. So that my queries performance will increase.

    Indexing the view may not be the best solution. What are the queries that are slow, what's the view's definition, what are the underlying tables' definitions and what are their indexes? Lastly, can you post the exec plan of the slow queries, saved as .sqlplan files, zipped and attached.

    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