SQL Index
W3Schools에서 제공하는 SQL Index 문서
**
Tutorials
**
**
References
**
**
Exercises
**
**
Certificates
**
**
Menu
**
**
Search field
*
×*
See More
**
**
Sign In
Sign Up
-->
user-anonymous -->
-->
-->
★
+1
-->
My W3Schools
-->
user-authenticated -->
Get Certified
Upgrade
Teachers
Spaces
Bootcamps
user-anonymous - action-btn -->
Get Certified
Upgrade
Teachers
Spaces
Bootcamps
user-authenticated - action-btn -->
*

My W3Schools
Tutorials
*
References
**
Exercises
**
Certificates
**
Spaces
Get Certified
Plus
Bootcamps
Academy
All our Services
**
Logout
**
*

*
*

*
*

*
*

*
×
Tutorials
Tutorials filter input
*
×
HTML and CSS
Learn
HTML
Tutorial
Reference
Learn
CSS
Tutorial
Reference
Learn
RWD
Tutorial
Learn
Bootstrap
Overview
Learn
W3.CSS
Tutorial
Reference
Learn
Sass
Tutorial
Reference
Learn
Colors
Tutorial
Reference
Learn
Icons
Tutorial
Reference
Learn
SVG
Tutorial
Reference
Learn
Canvas
Tutorial
Reference
Learn
Graphics
Tutorial
Learn
UTF-8 and Emojis
Reference
Learn
How To
Tutorial
Data Analytics
Learn
AI
Tutorial
Learn
Generative AI
Tutorial
Learn
ChatGPT-3.5
Tutorial
Learn
ChatGPT-4
Tutorial
Learn
Google Bard
Tutorial
Learn
Machine Learning
Tutorial
Learn
DSA
Tutorial
Learn
Data Science
Tutorial
Learn
NumPy
Tutorial
Learn
Pandas
Tutorial
Learn
SciPy
Tutorial
Learn
Matplotlib
Tutorial
Learn
Statistics
Tutorial
Learn
Excel
Tutorial
Learn
Google Sheets
Tutorial
Web Building
Create a Website
Create a Server
NEW
Where To Start
Web Templates
Web Statistics
Web Certificates
Web Development
Introduction to Programming
Introduction to HTML & CSS
Code Editor
Test Your Typing Speed
Play a Code Game
Web Development Tools
Cyber Security
Accessibility
Join our Newsletter
JavaScript
Learn
JavaScript
Tutorial
Reference
Learn
React
Tutorial
Learn
jQuery
Tutorial
Reference
Learn
Vue
Tutorial
Reference
Learn
Angular
Tutorial
Learn
AngularJS
Tutorial
Reference
Learn
JSON
Tutorial
Reference
Learn
AJAX
Tutorial
Learn
AppML
Tutorial
Reference
Learn
W3.JS
Tutorial
Reference
Web Building
Create a Website
Create a Server
NEW
Where To Start
Web Templates
Web Statistics
Web Certificates
Web Development
Introduction to Programming
Introduction to HTML & CSS
Code Editor
Test Your Typing Speed
Play a Code Game
Web Developer Tools
Cyber Security
Accessibility
Join our Newsletter
Backend
Learn
Python
Tutorial
Reference
Learn
SQL
Tutorial
Reference
Learn
MySQL
Tutorial
Reference
Learn
PHP
Tutorial
Reference
Learn
Java
Tutorial
Reference
Learn
C
Tutorial
Reference
Learn
C++
Tutorial
Reference
Learn
C#
Tutorial
Learn
R
Tutorial
Learn
Kotlin
Tutorial
Learn
Rust
Tutorial
Learn
Go
Tutorial
Learn
Django
Tutorial
Reference
Learn
PostgreSQL
Tutorial
Learn
TypeScript
Tutorial
Learn
ASP
Tutorial
Reference
Learn
Node.js
Tutorial
Reference
Learn
Raspberry Pi
Tutorial
Learn
Swift
Tutorial
Learn
Git
Tutorial
Learn
Bash
Tutorial
Learn
MongoDB
Tutorial
Learn
AWS Cloud
Tutorial
Learn
XML
Tutorial
Reference
Data Analytics
Learn
AI
Tutorial
Learn
Generative AI
Tutorial
Learn
ChatGPT-3.5
Tutorial
Learn
ChatGPT-4
Tutorial
Learn
Google Bard
Tutorial
Learn
Machine Learning
Tutorial
Learn
DSA
Tutorial
Learn
Data Science
Tutorial
Learn
NumPy
Tutorial
Learn
Pandas
Tutorial
Learn
SciPy
Tutorial
Learn
Matplotlib
Tutorial
Learn
Statistics
Tutorial
Learn
Excel
Tutorial
Learn
Google Sheets
Tutorial
Web Building
Create a Website
Create a Server
NEW
Where To Start
Web Templates
Web Statistics
Web Certificates
Web Development
Introduction to Programming
Introduction to HTML & CSS
Code Editor
Test Your Typing Speed
Play a Code Game
Web Developer Tools
Cyber Security
Accessibility
Join our Newsletter
**
×
References**
References filter input
×
HTML and CSS
HTML Tags
Reference
CSS
Reference
W3.CSS
Reference
Bootstrap 3
Reference
Bootstrap 4
Reference
Color
Names
Icons
Reference
SVG
Reference
Canvas
Reference
Sass
Reference
UTF-8 Charset
Reference
UTF-8 Emojis
Reference
JavaScript
JavaScript
Reference
HTML DOM
Reference
jQuery
Reference
Vue
Reference
Angular
Reference
JSON
Reference
AppML
Reference
W3.JS
Reference
Backend
Python
Reference
SQL
Reference
MySQL
Reference
PHP
Reference
Java
Reference
C
Reference
C++
Reference
Django
Reference
ASP
Reference
Node.js
Reference
XML
Reference
**
×
Exercises**
Excercises filter input
×
HTML and CSS
HTML
Exercise
Quiz
Challenge
CSS
Exercise
Quiz
Challenge
Bootstrap 3
Exercise
Quiz
Bootstrap 4
Exercise
Quiz
Bootstrap 5
Exercise
Quiz
Data Analytics
DSA
Exercise
Quiz
NumPy
Exercise
Quiz
Pandas
Exercise
Quiz
SciPy
Exercise
Quiz
Excel
Exercise
What is an Exercise?
What is a Quiz?
What is a Challenge?
What are Practice Problems?
JavaScript
JavaScript
Exercise
Quiz
React
Exercise
Quiz
jQuery
Exercise
Quiz
Vue
Exercise
Quiz
Angular
Exercise
Quiz
Backend
Python
Exercise
Quiz
Challenge
Problems
SQL
Exercise
Quiz
MySQL
Exercise
Quiz
PHP
Exercise
Quiz
Problems
Java
Exercise
Quiz
Challenge
Problems
C
Exercise
Quiz
Challenge
Problems
C++
Exercise
Quiz
Challenge
Problems
C#
Exercise
Quiz
Problems
R
Exercise
Quiz
Problems
Kotlin
Exercise
Quiz
Problems
Django
Exercise
Quiz
Node.js
Exercise
Quiz
Problems
PostgreSQL
Exercise
Quiz
TypeScript
Exercise
Quiz
Problems
Git
Exercise
Quiz
Bash
Exercise
Quiz
Go
Exercise
MongoDB
Exercise
Swift
Exercise
Quiz
Problems
AWS Cloud
Exercise
Quiz
-->
Data Analytics
DSA
Exercise
Quiz
NumPy
Exercise
Quiz
Pandas
Exercise
Quiz
SciPy
Exercise
Quiz
Excel
Exercise
What is an Exercise?
What is a Quiz?
What is a Code Challenge?
What is a Practice Problem?
**
×
Certificates**
Filter field for certifications
×
HTML and CSS
HTML
Certificate
Course
Bootcamp
CSS
Certificate
Course
Bootcamp
Bootstrap 3
Certificate
Course
Bootstrap 4
Certificate
Course
Bootstrap 5
Certificate
Data Analytics
DSA
Certificate
Data Analytics
Course
NumPy
Certificate
Course
Pandas
Certificate
Course
Excel
Certificate
Social Media
Course
What is a Certificate?
What is a Bootcamp?
Programs
Full Access
Best Value!
Front End
Certificate
Course
Web Dev.
Certificate
Course
Web App
Certificate
Course
Web Design
Certificate
Course
JavaScript
JavaScript
Certificate
Course
Bootcamp
React
Certificate
Course
Bootcamp
jQuery
Certificate
Course
Vue
Certificate
Programs
Full Access
Best Value!
Front End
Certificate
Course
Bootcamp
Web Dev.
Certificate
Course
Bootcamp
Web App
Certificate
Course
Web Design
Certificate
Course
Programs
Full Access
Best Value!
Front End
Certificate
Course
Bootcamp
Web Dev.
Certificate
Course
Bootcamp
Web App
Certificate
Course
Web Design
Certificate
Course
**
Backend
Python
Certificate
Course
Bootcamp
SQL
Certificate
Course
Bootcamp
MySQL
Certificate
PHP
Certificate
Course
Java
Certificate
Course
C
Certificate
C++
Certificate
Course
C#
Certificate
Course
R
Course
Django
Certificate
NodeJS
Certificate
Bootcamp
TypeScript
Certificate
Course
XML
Certificate
Course
Cyber Security
Certificate
Course
Accessibility
Certificate
Course
Python Apps on AWS
Course
AWS Training
Courses
-->
Data Analytics
DSA
Exam
Data Analytics
Course
NumPy
Course
Pandas
Course
Excel
Certificate
Social Media
Course
What is a Certificate?
×
All Our Services**
Dark mode

Services filter input
×
W3Schools offers a wide range of services and products for beginners and professionals,
**
helping millions of people everyday to learn and master new skills.
Free Tutorials
Enjoy our free tutorials like millions of other internet users since 1999
References
Explore our selection of references covering all popular coding languages
Create a Website
Create your own website with
**W3Schools Spaces**
- no setup required
Exercises
Test your skills with different exercises
Quizzes
Test yourself with multiple choice questions
Code Challenges
Test your skills with interactive code challenges
Get Certified
Document your knowledge
Log in / Sign Up
Create an account to track your progress
League
Earn XP and climb the ranks with different challenges
Upgrade
Become a PLUS user and unlock powerful features (ad-free, hosting, support,..)
Where To Start
Not sure where you want to start? Follow our guided path
Code Editor (Try it)
With our online code editor, you can edit code and view the result in your browser
Bootcamps
Learn from passionate instructors through live online sessions
Templates
We have created a bunch of responsive website templates you can use - for free!
Web Hosting
Host your own website, and share it to the world with
**W3Schools Spaces**
Create a Server
Create your own server using Python, PHP, React.js, Node.js, Java, C#, etc.
How To's
Large collection of code snippets for HTML, CSS and JavaScript
CSS Framework
Build fast and responsive sites using our free
**W3.CSS**
framework
Videos
Learn the basics of HTML in a fun and engaging video tutorial
Browser Statistics
Read long term trends of browser usage
Typing Speed
Test your typing speed
AWS Training
Learn Amazon Web Services
-->
Color Picker
Use our color picker to find different RGB, HEX and HSL colors.
Newsletter
Join our newsletter and get access to exclusive content every month
Set Goal
Get personalized learning journey based on your current skills and goals
-->
Emojis Reference
Check out our refererence page with all the emojis supported in HTML
😊
Code Game
W3Schools Coding Game! Help the lynx collect pine cones
UTF-8 Reference
Check out our full UTF-8 Character reference
Community
Chat, Learn and Connect with Us on Discord
Teachers
Contact us about W3Schools Academy for educational institutions
For Businesses
Contact us about W3Schools Academy for your organization
Contact Us
About sales:
sales@w3schools.com
About errors:
help@w3schools.com
Web Developer Tools
Free online tools to help with your everyday development tasks
*
*

*
*

*
*

*
*

*
×
*
❮
❯
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT ANGULAR ANGULARJS GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SWIFT SASS VUE GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE INTRO TO PROGRAMMING INTRO TO HTML & CSS BASH RUST TOOLS
HTML
CSS
JAVASCRIPT
SQL
PYTHON
JAVA
PHP
BOOTSTRAP
HOW TO
W3.CSS
C
C++
C#
REACT
R
JQUERY
DJANGO
TYPESCRIPT
NODEJS
MYSQL
SWIFT
-->
×-->
SQL Tutorial
SQL HOME SQL Intro SQL Syntax SQL Select SQL Select Distinct SQL Where SQL Order By SQL And SQL Or SQL Not SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Aggregate Functions SQL Min() SQL Max() SQL Count() SQL Sum() SQL Avg() SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL Union SQL Union All SQL Group By SQL Having SQL Exists SQL Any SQL All SQL Select Into SQL Insert Into Select SQL Case SQL Null Functions SQL Stored Procedures SQL Comments SQL Operators
SQL Database
SQL Create DB SQL Drop DB SQL Backup DB SQL Create Table SQL Drop Table SQL Alter Table SQL Constraints SQL Not Null SQL Unique SQL Primary Key SQL Foreign Key SQL Check SQL Default SQL Index SQL Auto Increment SQL Dates SQL Views SQL Injection SQL Parameters SQL Prepared Statements SQL Hosting
SQL References
SQL Data Types SQL Keywords
ADD
ADD CONSTRAINT
ALL
ALTER
ALTER COLUMN
ALTER TABLE
ALTER VIEW
AND
ANY
AS
ASC
BACKUP DATABASE
BETWEEN
CASE
CHECK
COLUMN
CONSTRAINT
CREATE
CREATE DATABASE
CREATE INDEX
CREATE OR REPLACE VIEW
CREATE TABLE
CREATE PROCEDURE
CREATE UNIQUE INDEX
CREATE VIEW
DATABASE
DEFAULT
DELETE
DESC
DISTINCT
DROP
DROP COLUMN
DROP CONSTRAINT
DROP DATABASE
DROP DEFAULT
DROP INDEX
DROP TABLE
DROP VIEW
EXEC
EXISTS
FOREIGN KEY
FROM
FULL OUTER JOIN
GROUP BY
HAVING
IN
INDEX
INNER JOIN
INSERT INTO
INSERT INTO SELECT
IS NULL
IS NOT NULL
JOIN
LEFT JOIN
LIKE
LIMIT
NOT
NOT NULL
OR
ORDER BY
OUTER JOIN
PRIMARY KEY
PROCEDURE
RIGHT JOIN
ROWNUM
SELECT
SELECT DISTINCT
SELECT INTO
SELECT TOP
SET
TABLE
TOP
TRUNCATE TABLE
UNION
UNION ALL
UNIQUE
UPDATE
VALUES
VIEW
WHERE
MySQL Functions
String Functions: ASCII CHAR_LENGTH CHARACTER_LENGTH CONCAT CONCAT_WS FIELD FIND_IN_SET FORMAT INSERT INSTR LCASE LEFT LENGTH LOCATE LOWER LPAD LTRIM MID POSITION REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SPACE STRCMP SUBSTR SUBSTRING SUBSTRING_INDEX TRIM UCASE UPPER
Numeric Functions: ABS ACOS ASIN ATAN ATAN2 AVG CEIL CEILING COS COT COUNT DEGREES DIV EXP FLOOR GREATEST LEAST LN LOG LOG10 LOG2 MAX MIN MOD PI POW POWER RADIANS RAND ROUND SIGN SIN SQRT SUM TAN TRUNCATE
Date Functions: ADDDATE ADDTIME CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATE DATEDIFF DATE_ADD DATE_FORMAT DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT FROM_DAYS HOUR LAST_DAY LOCALTIME LOCALTIMESTAMP MAKEDATE MAKETIME MICROSECOND MINUTE MONTH MONTHNAME NOW PERIOD_ADD PERIOD_DIFF QUARTER SECOND SEC_TO_TIME STR_TO_DATE SUBDATE SUBTIME SYSDATE TIME TIME_FORMAT TIME_TO_SEC TIMEDIFF TIMESTAMP TO_DAYS WEEK WEEKDAY WEEKOFYEAR YEAR YEARWEEK
Advanced Functions: BIN BINARY CASE CAST COALESCE CONNECTION_ID CONV CONVERT CURRENT_USER DATABASE IF IFNULL ISNULL LAST_INSERT_ID NULLIF SESSION_USER SYSTEM_USER USER VERSION
SQL Server Functions
String Functions: ASCII CHAR CHARINDEX CONCAT Concat with + CONCAT_WS DATALENGTH DIFFERENCE FORMAT LEFT LEN LOWER LTRIM NCHAR PATINDEX QUOTENAME REPLACE REPLICATE REVERSE RIGHT RTRIM SOUNDEX SPACE STR STUFF SUBSTRING TRANSLATE TRIM UNICODE UPPER
Numeric Functions: ABS ACOS ASIN ATAN ATN2 AVG CEILING COUNT COS COT DEGREES EXP FLOOR LOG LOG10 MAX MIN PI POWER RADIANS RAND ROUND SIGN SIN SQRT SQUARE SUM TAN
Date Functions: CURRENT_TIMESTAMP DATEADD DATEDIFF DATEFROMPARTS DATENAME DATEPART DAY GETDATE GETUTCDATE ISDATE MONTH SYSDATETIME YEAR
Advanced Functions
CAST
COALESCE
CONVERT
CURRENT_USER
IIF
ISNULL
ISNUMERIC
NULLIF
SESSION_USER
SESSIONPROPERTY
SYSTEM_USER
USER_NAME
MS Access Functions
String Functions: Asc Chr Concat with & CurDir Format InStr InstrRev LCase Left Len LTrim Mid Replace Right RTrim Space Split Str StrComp StrConv StrReverse Trim UCase
Numeric Functions: Abs Atn Avg Cos Count Exp Fix Format Int Max Min Randomize Rnd Round Sgn Sqr Sum Val
Date Functions: Date DateAdd DateDiff DatePart DateSerial DateValue Day Format Hour Minute Month MonthName Now Second Time TimeSerial TimeValue Weekday WeekdayName Year
Other Functions: CurrentUser Environ IsDate IsNull IsNumeric
SQL Quick Ref
SQL Examples
SQL Examples SQL Editor SQL Quiz SQL Exercises SQL Server SQL Syllabus SQL Study Plan SQL Bootcamp SQL Certificate SQL Training
SQL CREATE INDEX Statement
❮ Previous Next ❯
SQL CREATE INDEX Statement
The CREATE INDEX statement is used to create indexes
on tables in databases, to speed up data retrieval.
The users cannot see the indexes, they are just used to speed up searches/queries.
Note: Updating tables with indexes are more time-consuming than tables without indexes (because the indexes must also be updated). So, only create indexes on columns that are frequently searched against.
Types of Indexes: Non-unique and Unique
There are two types of indexes:
- `CREATE INDEX` - Creates a non-unique index (duplicate values are allowed)
- `CREATE UNIQUE INDEX` - Creates a unique index (duplicate values are not allowed)
CREATE INDEX Syntax
CREATE INDEX index_name
ON table_name (column1, column2, ...);
CREATE UNIQUE INDEX Syntax
CREATE UNIQUE INDEX index_name
ON table_name (column1, column2, ...); Note:** The syntax for creating indexes varies among different databases. Check the syntax for creating indexes in your database!
CREATE INDEX Example
The following SQL creates a non-unique index named "idx_lastname" on the "LastName" column in the "Persons" table:
CREATE INDEX idx_lastname
ON Persons (LastName);
If you want to create an index on a combination of columns, you can list the column names within the parentheses, separated by commas:
CREATE INDEX idx_lname_fname
ON Persons (LastName, FirstName);
DROP INDEX Statement
The DROP INDEX statement is used to remove an index.
SQL Server:
DROP INDEX table_name.index_name;
MySQL:
ALTER TABLE *table_name *DROP INDEX index_name;
MS Access:
DROP INDEX index_name ON table_name;
DB2/Oracle:
DROP INDEX index_name;
❮ Previous Next ❯
★
+1
Sign in to track progress
COLOR PICKER
REMOVE ADS
-->
*
PLUS SPACES GET CERTIFIED FOR TEACHERS BOOTCAMPS CONTACT US
×
Contact Sales
If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail: sales@w3schools.com
Report Error
If you want to report an error, or if you want to make a suggestion, send us an e-mail: help@w3schools.com
Top Tutorials
HTML Tutorial
CSS Tutorial
JavaScript Tutorial
How To Tutorial
SQL Tutorial
Python Tutorial
W3.CSS Tutorial
Bootstrap Tutorial
PHP Tutorial
Java Tutorial
C++ Tutorial
jQuery Tutorial
Top References
HTML Reference
CSS Reference
JavaScript Reference
SQL Reference
Python Reference
W3.CSS Reference
Bootstrap Reference
PHP Reference
HTML Colors
Java Reference
AngularJS Reference
jQuery Reference
Top Examples
HTML Examples
CSS Examples
JavaScript Examples
How To Examples
SQL Examples
Python Examples
W3.CSS Examples
Bootstrap Examples
PHP Examples
Java Examples
XML Examples
jQuery Examples
Get Certified
HTML Certificate
CSS Certificate
JavaScript Certificate
Front End Certificate
SQL Certificate
Python Certificate
PHP Certificate
jQuery Certificate
Java Certificate
C++ Certificate
C# Certificate
XML Certificate
**
FORUM ABOUT ACADEMY
W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and privacy policy.
Copyright 1999-2026 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.
-->