Tag Archives: how to increase speed of database execution

Indexing in mysql using php

indexes in mysql will increase the speed of your mysql queries. indexes are doing cloumn basis. for example if you have table with following fields ID,jobdescription,salary In this case to speed up the queries with jobdescription. then create an index for jobdescription. CREATE TABLE mydoubts_data ( jobdescription varchar, INDEX (jobdescription), salary INT(50), )