Sybase Adaptive Server Anywhere - Page 469

Chapter 9 SQL Statements
451
♦ ALLOW_DUP_ROW
Physical placement of an index is carried out differently in Adaptive
Server Enterprise and Adaptive Server Anywhere. The ON segment-
name clause is supported in Adaptive Server Anywhere, but segment-
name refers to a dbspace.
Unique indexes in Adaptive Server Anywhere permit entries that contain
NULL, and are otherwise identical. Unique indexes in Adaptive Server
Enterprise do not permit entries that contain NULL and are otherwise
identical.
Index names must be unique on a given table for both Adaptive Server
Anywhere and Enterprise.
♦ Create a two-column index on the
employee table.
CREATE INDEX employee_name_index
ON employee
( emp_lname, emp_fname )
♦ Create an index on the sales_order_items table for the prod_id column.
CREATE INDEX item_prod
ON sales_order_items
( prod_id )
Examples