View Single Post
  #2  
Old 02-21-2007, 07:16 AM
Terrell Terrell is offline
Senior Member
 
Join Date: Aug 2006
Posts: 108
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 18
Terrell is on a distinguished road
Default

The fragmentation of b does not affect a. Fragmentation happens when holes appear in the table because of deletions and updates. Table a at the unset, will be fresh. Both tables should however be optimized as needed, with time and usage. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - optimizing table!
View Single Post
  #2  
Old 02-21-2007, 07:16 AM
Terrell Terrell is offline
Senior Member
 
Join Date: Aug 2006
Posts: 108
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 18
Terrell is on a distinguished road
Default

The fragmentation of b does not affect a. Fragmentation happens when holes appear in the table because of deletions and updates. Table a at the unset, will be fresh. Both tables should however be optimized as needed, with time and usage. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote