Re: Ad-hoc/Dynamic SQL Performance
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 15 Feb 2008 21:04:18 -0800
Message-ID: <1203138234.151805@bubbleator.drizzle.com>
>> SQL> CREATE TABLE test1(field1 NUMBER(10) PRIMARY KEY);
>> 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;
You are wasting space: Writing more blocks than required. And violating more than a few "best practice" guidelines.
Date: Fri, 15 Feb 2008 21:04:18 -0800
Message-ID: <1203138234.151805@bubbleator.drizzle.com>
Doug Miller wrote:
> 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;
You are wasting space: Writing more blocks than required. And violating more than a few "best practice" guidelines.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Feb 15 2008 - 23:04:18 CST