RE: Is this Needed?
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>, "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- Date: Wed, 26 Oct 2005 11:18:41 -0400
I just checked and code tables are set to 10% while key application tables are
set to 30%. I'm pretty sure these aren't going to be changed. I don't think
there is any row chaining there. What are you getting at?
Don Freeman
Database Administrator 1
Bureau of Information Technology
Pennsylvania Department of Health
717-783-8095 Ext 337
-----Original Message-----
From: Christian Antognini [mailto:Christian.Antognini@xxxxxxxxxxxx]
Sent: Wednesday, October 26, 2005 11:05 AM
To: dofreeman@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Is this Needed?
Don
> Is this a waste of time?
As usually... it depends. IMHO there are three cases:
- you waste time
- you improve performance
- you decrease performance
Of course the third one is the real problem! And about it... a simple question:
how you will set PCTFREE before inporting the data?
Regards,
Chris
New Features Oracle Database 10g Release 2 seminars @
<http://www.trivadis.com> www.trivadis.com
Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Düsseldorf (23-Nov), Zürich (29-Nov), Stuttgart (13-Dec)
Other related posts:
