Easy Tutorial
Sql Having Sql Func Mid Sql Between Sql Drop Sql Wildcards Sql Join Inner Sql Join Full Sql Func Lcase Sql Where Sql Join Sql Func Round Sql Primarykey Sql Func First Sql Func Len Sql Distinct Sql Func Ucase Sql Function Sql Delete Sql Autoincrement Func Curtime Sql Update Sql Isnull Func Date Sub Sql Constraints Sql Intro Sql Dates Sql Select Into Sql Hosting Sql Create Table Sql Func Format Sql View Sql Func Count Sql Index Sql Like Sql Datatypes General Sql Datatypes Func Convert Sql Func Avg Sql Foreignkey Sql Func Sum Sql Join Right Func Curdate Sql Alias Sql Union Func Date Add Sql Groupby Sql Summary Sql In Sql Null Values Sql Syntax Sql Tutorial Sql Insert Into Select Sql And Or Sql Join Left Sql Func Now Func Date Sql Top Index Sql Create Db Sql Unique Sql Check Func Extract Sql Alter Sql Notnull Func Now Sql Select Sql Insert Sql Func Max Sql Exists Sql Func Min Func Date Format Func Datediff Mysql Func Getdate Sql Orderby Func Datediff Sql Func Last Sql Create Index Func Dateadd Sql Quickref Func Datepart
❮ Sql Func Last Func Dateadd ❯

SQL CREATE INDEX Statement

The CREATE INDEX statement is used to create indexes in tables.

Indexes allow database applications to find data more quickly without having to read the entire table.

Index

You can create indexes in tables to query data more quickly and efficiently.

Users cannot see the indexes; they are only used to speed up searches/queries.

Note: Updating a table with indexes takes more time than updating a table without indexes because the indexes themselves also need to be updated. Therefore, it is ideal to create indexes only on columns (and tables) that are frequently searched.

SQL CREATE INDEX Syntax

Creates a simple index on a table. Duplicate values are allowed:

SQL CREATE UNIQUE INDEX Syntax

Creates a unique index on a table. Duplicate values are not allowed: a unique index means that two rows cannot have the same index value.

Note: The syntax for creating indexes varies between different databases. Therefore, check the syntax for creating indexes in your database.

CREATE INDEX Example

The following SQL statement creates an index named "PIndex" on the "LastName" column of the "Persons" table:

If you want to index more than one column, you can list the column names in parentheses, separated by commas:

❮ Sql Func Last Func Dateadd ❯