Table optimiazation

[dominant]

In my database, there is a table wich consists of many foreign keys.
That table is increasing fastly and many rows get inserted or deleted.

So, now i want to defrag, optimize that table and its indexes.

Is there any relevant method to do that through SQL statements?

Thanks in advance.

[superwormy]

Gee... that was difficult to find...

http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=site%3Amysql.com+optimize+table

http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=site%3Amysql.com+create+index

http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=site%3Amysql.com+drop+index

[dannys]

see:

http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html

In short, it's:
"OPTIMIZE TABLE <tablename>"