Sybase IQ 12.4.0 Server User Manual


 
Adaptive Server IQ 12.4.0 Changes to “Using join indexes”
Release Bulletin for Digital UNIX 27
Creating star joins
The following should be added to Chapter 4 of the Adaptive Server IQ
Administration and Performance Guide just after the figure that shows the
sales_order table in a star join.
You can create this table using the following commands:
CREATE TABLE "DBA"."sales_order"
(
"id" integer NOT NULL,
"cust_id" integer NOT NULL
REFERENCES "DBA"."customer" ("id")
UNENFORCED,
"order_date" datetime NOT NULL,
"fin_code_id" char(2) NULL
REFERENCES "DBA"."fin_code" ("code")
UNENFORCED,
"region" char(7) NULL,
"sales_rep" integer NOT NULL
REFERENCES "DBA"."employee" ("emp_id")
UNENFORCED,
PRIMARY KEY ("id"),
);