subject:CREATE INDEX
syntax:CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
ON { TABLE | VIEW }
(
column_1 [ ASC | DESC ],
column_2 [ ASC | DESC ],
....
column_n [ ASC | DESC ]
)
[ WITH <index_option> ]
[ ON file_group ]
content:โดย <index_option> มีรูปแบบ ดังนี้
{ PAD_INDEX | FILLFACTOR = fillfactor | IGNORE_DUP_KEY | DROP_EXISTING |
STATISTICS_NORECOMPUTE | SORT_IN_TEMPDB }
example:CREATE TABLE person
(
id IDENTITY NOT NULL,
firstname VARCHAR(120) NOT NULL,
lastname VARCHAR(120) NOT NULL,
age INT NOT NULL
);
CREATE INDEX index_age
ON TABLE
(
age ASC
)
