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 K

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 cont

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 tabl

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 -