RE: Partition Tables

Thanks for that

Lee

> -----Original Message-----
> From: Diana Duncan [mailto:Diana_at_fileFRENZY.com]
> Sent: 25 August 2000 16:45
> To: Multiple recipients of list ORACLE-L
> Subject: 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-----
> Sent: Friday, August 25, 2000 8:17 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> --
> Author: Diana Duncan
> INET: Diana_at_fileFRENZY.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).
>
>
> ======================================================
> This message has been scanned and checked by MIMESWEEPER.
Received on Tue Aug 29 2000 - 02:44:34 CDT