Re: inline out-of-line

From: Vu Pham <vu_at_sivell.com>
Date: Tue, 17 Feb 2004 12:37:00 -0600
Message-ID: <c0tn1u$1a9fpe$1@ID-219297.news.uni-berlin.de>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1077040345.937452_at_yasure...
> Vu Pham wrote:

[...]
> > Could you please tell me a little bit more about this ? I can't find the
> > relationship between tablespace and constraints. ( You can see that I am
> > just a rookie in this field ).
>
> ALTER TABLE mytable
> ADD CONSTRAINT pk_mytable
> PRIMARY KEY (pk_column)
> USING INDEX
> PCTFREE 5
> TABLESPACE tspace06;
>
> same "USING INDEX ... " syntax for unique constraint.

Aah, I think I see your point now .

[...]

> I can think of no advantage to inline constraints unless one is
> lazy and doesn't specify the full syntax required or doesn't put
> constraints on all possible fields which is the recommended
> practice.

Thanks for the advice. I have the feeling that you are also a serious C developer :-)

Vu Received on Tue Feb 17 2004 - 12:37:00 CST