Hi,
I have several related database indexing questions:
1)In trying to run SHOW INDEX FROM table my client (MySQL GUI 1.7.4) just
hangs, or else this takes many minutes. MySQL 3.23.33 What could be wrong?
I tryed an ALTER TABLE index creation on this table a while ago. Could it
be tied up with creating an index?
2)How long should it take to index a column (on ~ 800 rows and CHAR(35))?
3) After successfully returning from an ALTER TABLE adding an index on a
table (took seconds) the second column ran for ......? (stopped it). Is
there a problem running more than 1 index on a table!?
Muchas Gracius!
Paul
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
