Re: Ad-hoc/Dynamic SQL Performance

From: Doug Miller <spambait_at_milmac.com>
Date: Fri, 15 Feb 2008 13:16:55 GMT
Message-ID: <bhgtj.419$Mw.380@nlpi068.nbdc.sbc.com>


In article <1203049592.136561_at_bubbleator.drizzle.com>, DA Morgan <damorgan_at_psoug.org> wrote:

One thing I don't understand: why is this
>
>SQL> CREATE TABLE test1(field1 NUMBER(10) PRIMARY KEY);

inferior to this?
>
>SQL> CREATE TABLE test2(field1 NUMBER(10))
> 2 PCTUSED 99
> 3 PCTFREE 0;
>
>SQL> ALTER TABLE test2
> 2 ADD CONSTRAINT pk_test2
> 3 PRIMARY KEY (field1)
> 4 USING INDEX
> 5 PCTFREE 0;
Received on Fri Feb 15 2008 - 07:16:55 CST

Original text of this message