MySQL

Creating Index in Mysql - https://www.howtoforge.com/when-to-use-indexes-in-mysql-databases - https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html - http://www.mysqltutorial.org/?s=index Stored procedure: - https://www.sitepoint.com/stored-procedures-mysql-php/ - https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html - http://www.mysqltutorial.org/stored-procedures-parameters.aspx Notes: - Usage of Index in SQL query, I mean when column is indexed, sample queries to use the index name while retrieving data.. Ex: select * from table1 use index(index_name) where col1= "123"  ----- need to try. Here in the above example, index_name is index created on col1. - Sample Stored procedure queries. - Any doc related to mysql would be great