AW: AW: Index of packed table not used

Hi Victoria! After running myisamchk -r it works. Thanks a lot! Kai -Ursprüngliche Nachricht- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 15. November 2002 17:41 An: [EMAIL PROTECTED] Betreff: Re: AW: Index of packed table not used Hello Kai, Friday

Re: AW: Index of packed table not used

Hello Kai, Friday, November 15, 2002, 1:27:01 PM, you wrote: BK Hi! BK Thank you for your answer! BK Index was used befor, but i didn't run myisamchk -rq. BK Is it necessary? Yes, you must re-create indexes: http://www.mysql.com/doc/en/myisampack.html -- For technical support

re: Index of packed table not used

Bungarz, Wednesday, November 13, 2002, 11:13:18 AM, you wrote: BK Hi! BK We are using mysql, version 4.0.4 beta on windows 2000 Server. BK I packed a table with 100 million rows, using myisampack. BK Now queries don't use the index of this table. BK It's not possible for me, to work with table

Index of packed table not used

Hi! We are using mysql, version 4.0.4 beta on windows 2000 Server. I packed a table with 100 million rows, using myisampack. Now queries don't use the index of this table. It's not possible for me, to work with table scan. So, what can i do? Kai