sql create index
snippet in sql

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."