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.
- Kirti -----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 >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
