What's the default fill factor on MyISAM B-Tree
indexes? I know it's 15/16 by default for InnoDB, but
nothing is mentioned about MyISAM.
For example, if I'm going to create read-only tables
and index them, I'd like the fill factor to be 100%
since there won't be updates and therefore I'm not
worried about page splits.
Is there a way to control it, the same way MS SQL
Server allows you to specify the fillfactor for
indexes and primary keys?
Thanks!
Homam
__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250
| Thread |
|---|
| • Index fill factor | Homam S.A. | 5 Jan |