Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: Will table size affect data retrival time?

    I have a huge table which is currently holding data from 7 different category.
    Should i separate the data into 7 different tables or leave them as it is?

    Which way would shorten the data retrival time?

  2. #2
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Re: Will table size affect data retrival time?

    Originally posted by abones
    I have a huge table which is currently holding data from 7 different category.
    Should i separate the data into 7 different tables or leave them as it is?

    Which way would shorten the data retrival time?
    You may create a partitioned table.

Posting Permissions

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