Hi - I've been trying different prefixes on my index & I'm getting funny results: in short:
>> an index on a column-prefix is bigger than an index on the whole column << using "show table status" I get total index size as: 12147712 - without index 13239296 - with full index 13455360 - with index on first 5 chars 13157376 - with index on first 3 chars - i.e., the prefix-index is *bigger* than the full index - does this make sense? The column is a varchar(255). About 2/3 of the entries are empty-string, & the other 1/3 have avg length 8-chars, std 3.5. Would making the empty-strings null make any difference to the size of the index? Thanks in advance everybody. (Using 4.0.20) P.S. - there's not a simple way of getting size of individual index sizes is there? Is it a direct function of the cardinality when you do "show indexes on [table]" Tom. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]