Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 16. Using Indexes to Improve Performance
The CREATE INDEX statement, as with many other statements in SQL, varies greatly among different relational database vendors . Most relational database implementations use the CREATE INDEX statement:
CREATE INDEX INDEX_NAME ON TABLE_NAME
The syntax is where the vendors start varying greatly on the CREATE INDEX statement options. Some implementations allow the specification of a storage clause (as with the CREATE TABLE statement), ordering (DESCASC), and the use of clusters. You must check your particular implementation for its correct syntax.