Sql create index

This article is tagged with: Sql create index and mysql

sql create index

CREATE INDEX index_name
ON tableName (tableColumn);

what is an index in sql

"An index is an on-disk structure associated with a table
or view that speeds retrieval of rows from the table or view.
These keys are stored in a structure (B-tree) that enables SQL Server
to find the row or rows associated with the key values quickly and efficiently."

This article is tagged with: Sql create index and mysql