Adaptive Server IQ 12.4.0 | Changes to “Using join indexes” |
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"),
);
Release Bulletin for Digital UNIX | 27 |
