xxxxxxxxxx
-- don't miss 'ON TableName (ColumnName)
CREATE INDEX idx_salary
ON employees (salary DESC);
xxxxxxxxxx
CREATE INDEX idx_CustomerName ON Customers (CustomerName);
-- Kindly upvote this answer if it helped you.
xxxxxxxxxx
-- create table
CREATE TABLE Colleges (
college_id INT PRIMARY KEY,
college_code VARCHAR(20) NOT NULL,
college_name VARCHAR(50)
);
-- create index
CREATE INDEX college_index
ON Colleges(college_code);
-- Index creation example with re-runnable script
-- For some prefixing indexes with IDX_ seems good
IF NOT EXISTS(SELECT 1 FROM [sys].[indexes] WHERE [name] = 'IX_TableName_IncludedColumn1_IncludedColumn2')
BEGIN
CREATE INDEX [IDX_TableName_IncludedColumn1_IncludedColumn2] ON [TableName] ([IncludedColumn1], [IncludedColumn2]);
END
-- Others prefix indexes with IX_
IF NOT EXISTS(SELECT 1 FROM [sys].[indexes] WHERE [name] = 'IX_TableName_IncludedColumn1_IncludedColumn2')
BEGIN
CREATE INDEX [IX_TableName_IncludedColumn1_IncludedColumn2] ON [TableName] ([IncludedColumn1], [IncludedColumn2]);
END
-- Example table creation re-runnable
IF OBJECT_ID('TableName', 'U') IS NULL
BEGIN
CREATE TABLE [TableName] (
[TableNameId] INT PRIMARY KEY,
[IncludedColumn1] VARCHAR(20) NOT NULL,
[IncludedColumn2] VARCHAR(50) NOT NULL
);
END