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>

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.org

Received on Fri Feb 15 2008 - 23:04:18 CST