sql, query
thanks for the note brent.
> If you don't have any variable length
> fields (ie. varchar) then all your record
> lengths are exactly the same and the
> "empty" space can be reused for new records,
> preventing fragmentation.
i think we can do this. since this rotateable table is only for
calculations, it only contains integer values. but is there any
documentationm for such issues? my guess is that although the table may
not lead to fragmentation, the index may?
> When you say "truncate entirely" do you mean you're are
> performing a
> "DELETE FROM TABLE"?
yes, either that, or
TRUNCATE TABLE table1
is there any reason one is better than the other?
thanks for any advice!
.ep
__________________________________________________
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
