Employers
Jobseekers
Recruiting Partners
Login
Join Hyring
Join Hyring
Lesson
Introduction
Syntax
Select
Select Distinct
Where
Order By
And, Or, Not
Insert Into
Null Values
Update
Delete
Select Top
Aggregate Functions
MIN and MAX
COUNT
SUM
AVG
Like
Wildcards
In
Between
Aliases
Joins
Inner Join
Left Join
Right Join
Full Join
Self Join
Union
Group By
Having
Case
Comments
Operators
Create DB
Drop DB
Create Table
Drop Table
Alter Table
Constraints
Not Null
Unique
Primary Key
Foreign Key
Check
Default
Indexes
Auto Increment
Dates
Views
Injection
Back to lesson
SQL Indexes
Create a basic index
Create a unique index
Index on more than one column
Run
Language:
SQL
Change Theme
Change orientation
CREATE INDEX idx_lastname ON Employees (LastName);
CREATE INDEX idx_lastname ON Employees (LastName);
Output
Click Run to execute this code.