what EXACTLY...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
hob_goblin
Forum Regular
Posts: 978
Joined: Sun Apr 28, 2002 9:53 pm
Contact:

what EXACTLY...

Post by hob_goblin »

does optimizing a table do?
User avatar
mydimension
Moderator
Posts: 531
Joined: Tue Apr 23, 2002 6:00 pm
Location: Lowell, MA USA
Contact:

Post by mydimension »

over the course of time, data will be inserted and deleted from your tables, leaving them defragmented (much like a FAT16/FAT32/NTFS harddrive). optimizing cleans up the unused space and compacts the table to be size efficient again.
Post Reply