1 reason and 1 reason only. To speed up queries. The flip side of that is if you have an index that is not being used by a query somewhere, get rid of it.
=C= * * Cal Evans * Techno-Mage * http://www.calevans.com * ----- Original Message ----- From: "ally" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 2:59 AM Subject: Using indexes on mysql. > hi all, > > this will sound very stupid, but i guess it will be helpful to mysql newbies > like me. > > Here's my Qu : What's the use of using indexes in mysql ? Why do we create > an index anyway ? > > thank you, > > regards > > ally > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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