Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Partitions

RE: Partitions

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 17 Jan 2002 06:41:24 -0800
Message-ID: <F001.003F28E9.20020117063054@fatcity.com>

Having said all that, I suggest that you keep the statistics on these partitions up to date to help the optimizer... Of course, if data in some of the partitions become static, there is no need to analyze those partitions.

-----Original Message-----
Sent: Thursday, January 17, 2002 8:02 AM To: Multiple recipients of list ORACLE-L

Hamid,
Partitions are basically for the use of Oracle. It allows you to break apart a large table into several smaller sections to help in the management of the table data and to help Oracle find the data you requested. Under ideal conditions, Oracle will only select the smallest area to search for the data you have requested. If the table is 1 tablespace and large in size, it can take an enormous amount of resources to find the data you selected. If the table is partitioned correctly, Oracle will only search the partition/s that it needs to find your data.
The application code does not need to be changed. The application will request data from a table and Oracle will determine which partition to use.
ROR mª¿ªm

>>> hamid.alavi_at_quovadx.com 01/16/02 04:06PM >>>
List,
If we use partitioning for a big tables after finish development, do we have
to change the code for accReceived: from CONNECT-MTA by galotteressing diffrent partition or this will handle
by
oracle itself.
Thanks

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 17 2002 - 08:41:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US