Home Forums Programming General Datatype performance - in theory there should be a difference, but in practice is there? RE: Datatype performance - in theory there should be a difference, but in practice is there?

  • September 26, 2016 at 12:05 pm

    #1903168

    pcd_au (9/26/2016)

    However my original question did (try to) restrict answers to data warehousing style applications.

    Understood that from the beginning. A data warehouse application isn't much different than anything else when it comes to performance. One of the purposes of a data warehouse is performance. Just because some of the tables are denomalized or pre-aggregated for performance, it doesn't change some of the basic rules of performance. Using the correct data types and matching them between tables is still one of the important precursors to performance.

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