Help with proper indexes

  • If the IDENTITY column is used properly and not just as a row number, then you DO need to consider the joins because they will be mostly by IDENTITY. 😉

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Thank you, guys, for all the input, I was off work because of the snow and the kids were home so I have not had a chance to read the comments.  I will read them and see if I have any further questions.  My current plan is to keep the ID field and my current indexes because it is working fine.

    Then I will probably make a copy of the table and try making the primary key the import date/Car Initial/Car number and see how that works.

    Thanks for all the info and great resources.

  • railman wrote:

    My current plan is to keep the ID field and my current indexes because it is working fine.

    Then I will probably make a copy of the table and try making the primary key the import date/Car Initial/Car number and see how that works.

    Best plan yet.  "One good test is worth a thousand expert opinions".

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 16 through 17 (of 17 total)

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