Andrew Mobbs <andrewm_at_chiark.greenend.org.uk> wrote:
>Michiel Brunt <mbrunt_at_inergy.nl> wrote:
>>We use Oracle 8i for a data warehouse. There is a large (>20 mln) fact table
>>and smaller dimension tables (max 100.000).
>>Parallel processing should be useful, but what tables should be altered for
>>parallel query?
>
>Do you mean partitioning for parallel update and delete? Selects are
>parallelised just by having parallel server enabled, and putting a
>parallel clause in the select.
Sorry, I meant parallel query of course, not OPS! See Metalink
Note:39599.1
--
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
Received on Mon Dec 03 2001 - 07:51:59 CST
