The CREATE INDEX Command

Team-Fly    

 
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:

 graphics/syntax_icon.gif 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.


Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net