Re: number of rows in EXPLAIN for unpacked vs packed tables

2006-07-01 Thread C.R.Vegelin
AIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL PROTECTED]> Cc: Sent: Friday, June 30, 2006 4:36 PM Subject: Re: number of rows in EXPLAIN for unpacked vs packed tables Cor - Those numbers are an estimate, not a hard number, of how many rows MySQL thinks it will have to exmaine

Re: number of rows in EXPLAIN for unpacked vs packed tables

2006-06-30 Thread Dan Buettner
Cor - Those numbers are an estimate, not a hard number, of how many rows MySQL thinks it will have to exmaine to find what you're looking for. They could be different because your compressed table is brand-new and all the indexes are clean and up to date, whereas your original table has possibly