RE: Partition Tables

For the best performance and usage of the partitions, you'll want to make sure the partition key is the first item in any indices. Also, you will want to check the SQL in your application to make sure that SQL statements reference the partition key (where applicable). Otherwise, partitioning seems pretty transparent -- at least so far, for our application.

Regards,
Diana

-----Original Message-----
From: Lee Robertson [mailto:Lee.Robertson_at_qspgms.com] Sent: Friday, August 25, 2000 8:17 AM
To: Multiple recipients of list ORACLE-L Subject: Partition Tables

All,

We have a legacy application running on Oracle 7.3 which we are migrating to Oracle 8.

We are looking at partitioning tables. Can anyone point me to any ptifalls/gotchas and any sort of problems that we may encounter. Will we have to make changes in our base code for example to access data in these partitions etc.

Regards

Lee

-- 
Author: Lee Robertson
  INET: Lee.Robertson_at_qspgms.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).