Home Forums Database Design Design Ideas and Questions Table Splitting RE: Table Splitting

  • March 22, 2010 at 7:16 am

    #1137571

    DBTeam (3/22/2010)

    Hi All,

    I have 28+ million table with 30 columns. Now we want to split into

    multiple tables.

    It having the information

    like name info, address info , company info, employees, sales, webaddress..

    This having Rowid as identity data type and

    email having primary key.

    daily we want all these columns data.

    Please suggest us the better way to split the table.

    B'coz it hurts the performance of querying process.

    Are you importing this data into some form of staging table daily or ???

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