subject:"index question part 2"

Re: index question part 2

2004-02-06 Thread Egor Egorov

rmck [EMAIL PROTECTED] wrote: I understand that I need to update the db's cardinality for this table I need speed Should I run CHECK TABLE or ANALYZE TABLE or myismachk -a?? I need the quickest one because with 56179085 records this could take a while... myisamchk -a does the

index question part 2

2004-02-04 Thread rmck

I understand that I need to update the db's cardinality for this table I need speed Should I run CHECK TABLE or ANALYZE TABLE or myismachk -a?? I need the quickest one because with 56179085 records this could take a while... Thanks for the replies Rob -Forwarded