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"),
);