Sybase ADAPTIVE SERVER IQ 12.4.0 Manuel d'utilisateur télécharger pdf (Page 27)

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

);

1 2 ... 22 23 24 25 26 27 28 29 30 31 32 ... 51 52

Pas de commentaire

Sybase ADAPTIVE SERVER IQ 12.4.0 Manuel d'utilisateur Page 27