Re: Is it a good idea to have primary key on DW table
Date: Wed, 04 Aug 2010 22:17:31 +0800
Was the Index created as a GLOBAL index or a LOCALly partitioned index ? Your script shows an "ALTER TABLE .. SPLIT PARTITION" being done without an UPDATE GLOBAL INDEXES.
At 01:02 PM Wednesday, Anupam Pandey wrote:
>In another test run I was expecting the loading of that fact table
>to take more as the new partitons get added to that table with
>primary key enabled.
>But it turned out to be a flat (almost) time for insert or loading
>for that table with primary key enabled.
>I was expecting it to take more time with the increase in number of
>rows because primary key validation will be a serial job ( correct
>me if i am wrong)
>and with the increase in data oracle will have to do more work with
>subsequent loading .
>I have atached the log file and script..
>Plz let me know your thought on it .
>Thanks And Regards,
Hemant K ChitaleReceived on Wed Aug 04 2010 - 09:17:31 CDT