sql server 2000

来自「JAVA下的SQL_System的建立」· 代码 · 共 20 行

--第八章——创建和使用索引

--CREATE INDEX的语法如下：
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
    ON { table | view } ( column [ ASC | DESC ] [ ,...n ] ) 
[ WITH < index_option > [ ,...n] ] 
[ ON filegroup ]
< index_option > ::= 
    { PAD_INDEX |
        FILLFACTOR = fillfactor |
        IGNORE_DUP_KEY |
        DROP_EXISTING |
    STATISTICS_NORECOMPUTE |
    SORT_IN_TEMPDB  
}

--通过索引进行查询工作：
SELECT * 
FROM CUSTOMERS  WITH (INDEX(REGION))
WHERE REGION = 'OR' AND CITY = 'Elgin'