Joseph D wrote:
Is it possible for you to tell me where I should add my indexes? I have read the manual but can't figure out where I must add them to my tables.If you have lots of disk space, add them to every column that is in your query(ies). Then see what the EXPLAIN output says, and delete the indexes that aren't used (except primary keys and UNIQUE indexes used for integrity).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
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
