Custom Search
www.rocket99.com : Technical Guides
Sybase
Oracle
UNIX
Javascript
Technical Guides
Sybase
Oracle
UNIX
Javascript
Of Interest
Business Intelligence and Analytics
Oracle Training
Sybase » DDL » Design »
Creating an index
Sample index creates:
create unique clustered index emp_idx
on employee (emp_id)
go
create index emp_name_idx
on employee (lname)
go
-- With sorted data!
create unique clustered index pk_invoice_data on invoice_data with sorted_data on segment1
go
Sybase : Related Topics
Sybase : DDL : Sybase data types
Sybase : DDL : Creating a table
Sybase : DDL : Altering a table
Sybase : DDL : Clustered vs non-clustered indexes
Sybase : DDL : Creating a constraint
Sybase : DDL : Table Partitioning
Sybase : DDL : Modifying a Colunm
Sybase : DDL : Alter a column
Sybase Web Site
Sybase Mobile Web Site
Oracle Web Site
Get the latest Rocket99 news and tech tips via
Site Index
About this Guide to Sybase, Oracle, and UNIX
Contact Us
Advertise on this site
Copyright © 2012
Stoltenbar Inc
All Rights Reserved.