Index is a set pointers reference to the specific row in the table.It will make Sql search as much more fast.
Example:
CREATE INDEX IndexName
ON TableName (ColumnName1,ColumnName2).
For More information:
http://www.databasejournal.com/features/mysql/article.php/1382791/Optimizing-MySQL-Queries-and-Indexes.htm
No comments:
Post a Comment