ally,
Thursday, June 13, 2002, 10:59:00 AM, you wrote:
a> this will sound very stupid, but i guess it will be helpful to mysql newbies
a> like me.
a> Here's my Qu : What's the use of using indexes in mysql ?
Indexes are used for query optimization. Rows in the table are
unodered and if there are no index in the table MySQL will scan all rows
to find what is requested. Look at:
http://www.mysql.com/doc/T/a/Table_and_index.html
http://www.mysql.com/doc/M/y/MySQL_indexes.html
http://www.mysql.com/doc/I/n/Indexes.html
a> Why do we create an index anyway ?
http://www.mysql.com/doc/C/R/CREATE_INDEX.html
a> thank you,
a> regards
a> ally
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
