Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning indexing a table having million of records RE: indexing a table having million of records

  • August 3, 2014 at 9:35 am

    #1734686

    raj.prabhu001 (8/3/2014)

    Hello,

    I have a fact table which has six field now and I have created non clustered index on all fields.

    It will also have more fields later with millions of records .

    Please suggest me my indexing will help on this table or should I create index in some other way to optimise performance .

    Thanks

    Can you provide execution plan, query statistics and sample queries?

    These are the kinds of things that are required to make tuning suggestions.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events