Sybase ADAPTIVE SERVER IQ 12.4.0 Manuale Utente Scaricare il pdf (Pagina 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

Nessun commento

Sybase ADAPTIVE SERVER IQ 12.4.0 Manuale Utente Pagina 27