RE: Is this Needed?

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_at_trivadis.com] Sent: Wednesday, October 26, 2005 11:05 AM To: dofreeman_at_state.pa.us
Cc: oracle-l_at_freelists.org
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)

--
http://www.freelists.org/webpage/oracle-l