MySQL IndexesArjun Panwar14yAsked Nov 30, 2011, 6:33 AM1.6kDatabases & DBAWhat are the purposes of MySQL indexes?
Satyapriya Nayak14y agoPosted Nov 30, 2011, 7:16 AMHi Arjun,Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rowsReferhttp://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.htmlhttp://www.tizag.com/mysqlTutorial/mysql-index.phpThanks
Arjun PanwarPosted Nov 30, 2011, 10:56 PM
Satyapriya NayakPosted Nov 30, 2011, 7:16 AM
Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows
Refer
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
http://www.tizag.com/mysqlTutorial/mysql-index.php
Thanks