Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    56

    Unanswered: Rebuilding Indexes?

    If a table is truncated and filled with new data, is it necessary to do a rebuild on an index, or is it automatically maintained?

    What about with just inserting some rows into a table? Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    when you say "filled"..by what process?

    How many rows of data are we talking about

    Also is the data sorted?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2009
    Posts
    56
    Quote Originally Posted by Brett Kaiser View Post
    when you say "filled"..by what process?

    How many rows of data are we talking about

    Also is the data sorted?
    When I say filled, I mean an INSERT statement. So...
    truncate table1

    insert into table1
    select name, address from table2
    where userid = 10

    The rows really depend. I was just kind of curious if there was a general rule of thumb. I have one table that is 30 million rows, and another that has 300k rows. About 10 columns in each table.

    The data is not sorted.

Posting Permissions

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