Search History and Resolution

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