Home Forums Database Design Design Ideas and Questions Lots of Key Lookups vs. UniqueIdentifier Clustered Index RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

  • November 17, 2012 at 4:36 pm

    #1560066

    opc.three (11/17/2012)

    Jeff Moden (11/17/2012)

    opc.three (11/16/2012)

    You'll have to test because as usual, it will depend on your workload and data. Here is a great place to start:

    Does Index Fragmentation Matter with SSD’s?

    Apologies... I don't understand. What do SSD's have to do with SSS?

    Fusion IO is a solid state solution. The ones I have used fit into a PCI Express slot. Therefore I assumed that SSS (sic) meant Solid State Storage which some people say in place of SSD, or Solid State Drives.

    Ah... got it. Thanks, Orlando. I haven't had the pleasure of working with SSDs, yet.

    --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)