you are at Encyclopedia of SQL >> CREATE INDEX
CREATE INDEX
Create index for specified column.Syntax
CREATE INDEX index_name
ON `table_name` (`column_name`[,`column_name2`])
With indexes there is quicker searching in database but UPDATE operation takes more time
[ wróć na górę strony ]
Creating index can be different in different database servers.