var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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...
Originally Posted by Brett Kaiser
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.