Post reply

Best Index to Create

  • February 20, 2012 at 9:15 pm

    #257068

    Hi All,

    I have a Typical 3 table Types

    Type: One Column with Identity, One Column with Code, StartDate & Enddate for SCD (CI1,CC1, SD, ED - Table1)

    Type2: One Column with Identity, One Column with Code, One Column with FK, StartDate & Enddate for SCD(CI1,CC1, CF1, SD, ED - Table2)

    Type 3: Two Columns with FKs, StartDate & Enddate for SCD(CF1,CF2, SD, ED - Table3)

    Can you please suggest the best index that can be created, so that the Data / Loading process does not get Effected and makes it more Smooth.

  • February 20, 2012 at 9:59 pm

    #1449472

    check this link

    http://sqlserverpedia.com/wiki/Best_Practices_for_Creating_Indexes

    java programming

  • February 21, 2012 at 1:49 am

    #1449518

    Without knowing the queries that you are running, absolutely no way to say what should be indexed. Indexes are based on the queries that run against the tables. Just seeing the tables is not enough

    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 3 posts - 1 through 2 (of 2 total)

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