Re: IOT, memory and transaction time

deja_at_2bytes.co.uk wrote:

> Here is the DDL...
>
> New DDL:
> CREATE TABLE R_TABLE1 (
> deleted INTEGER NOT NULL,
> versionNo INTEGER NOT NULL,
> Id char(32) NOT NULL,
> Rel char(32) NOT NULL,
> CONSTRAINT R_TABLE1_1 PRIMARY KEY(versionNo,Id, Rel),
> FOREIGN KEY (deleted) REFERENCES T_TRANSACTIONS (TransNum),
> FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS (TransNum),
> CHECK (versionNo >= deleted))
> ORGANIZATION INDEX;
>
> CREATE INDEX R_TABLE1_2 ON R_TABLE1 (Id, versionNo);
>
>
> Old DDL:
> CREATE TABLE R_TABLE1(
> deleted INTEGER NOT NULL,
> versionNo INTEGER NOT NULL,
> Id char(32) NOT NULL,
> Rel char(32) NOT NULL,
> FOREIGN KEY (deleted) REFERENCES T_TRANSACTIONS (TransNum),
> FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS (TransNum),
> CHECK (versionNo > deleted));
>
> Thanks for any advice
> Phil

SQL> SELECT keyword

   2 FROM gv$reserved_words
   3 WHERE keyword IN ('DELETED', 'VERSIONNO', 'ID', 'REL');

KEYWORD

SQL>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org