Results 1 to 5 of 5
  1. #1
    Join Date
    May 2011
    Posts
    6

    Unanswered: Hypothetical Performance Question

    I realize it depends on the machine it's run on, but generally speaking can someone give a rough answer?

    If a table has 10 columns, would 6,000,000 records be alot to run a select statement on (retrieves maybe 500 ~ 1000 rows).


    What about if the rows and columns were reversed? Example:
    If a table has 500 ~ 1000 columns, would 12000 records be alot to run a select statement on?

    Readers Digest: Is it better to have hundreds of columns or hundreds of rows? The table could theoretically have 60,000 rows per year using 10 columns, OR about 280 rows per year using 500 ~ 1000 columns.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    If the table is properly indexed with good statistics, and the query is SARG-able, then the query on the 6,000,000 row table will take nearly no time at all.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    All other things being equal the number of data blocks containing the desired data remains the same.

    Which pizza can you eat faster; one with 4 slices or one with 12 slices?
    Pizza is same size regardless of how it is sliced!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Feb 2004
    Location
    Chennai
    Posts
    53
    and you ll be putting effort managing and manipulating the loooooooong table
    -Mathan
    For a quick pocket reference of oracle refer http://pocketoracle.blogspot.com/

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Length of the table is immaterial.

    Getting 500 - 1000 rows from a 6,000,000 row table should be an index seek.

    Getting 500 - 1000 rows from a 12,000 row table should be a table scan.

Posting Permissions

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