Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2011
    Posts
    32

    Unanswered: Vertical Partitioning and Table Size

    Hi,

    I read in an article that by moving less-used columns to a separate table can help execute queries faster. My question is that if I'm selecting only a couple of columns in my query that I need at this moment, how does it matter if other columns in the same table have a lot of data in them?

    Appreciated...

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    have you done any tests to prove that this statement is
    A) valid
    B) valid for your proposed application
    and if it is valid is it significantly faster, and therefore implementing
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2011
    Posts
    32
    I have a sample data table with half a million records. It has a URL column with index on its first 35 characters. I just wanna to learn a little theoretically before I split the table and move the URL column to a separate table.
    Last edited by akrashdi; 10-27-12 at 08:11.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    as before
    you have enough data
    get some metrics to prove an assertion either way
    before you go dreaming about finding a fix for a problem make certain you have a problem.
    with your half million+ rows you should have a reasonable data set to make accurate measurements as to whether you have a problem OR NOT.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jul 2011
    Posts
    32
    Alright, I will do more experiments and see how it turns out, thanks.
    Last edited by akrashdi; 10-27-12 at 09:42. Reason: Change of mind

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •