Re: RE: Global index on partitioned table
- From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- To: "Sheehan, Jeremy" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- Date: Tue, 23 Nov 2010 08:09:34 +0800
.... praventing the indexes from becoming *UNUSABLE*. .... is what U meant.
Hemant K Chitale
http://hemantoracledba.blogspot.com
sent from my smartphone
On Nov 23, 2010 7:50 AM, "Hemant K Chitale" <hemantkchitale@xxxxxxxxx>
wrote:
If you are issuing DELETEs *before* the TRUNCATE, then the UPDATE GLOBAL
INDEXES advantage is in preventing the indexes from becoming INVALID. The
undo and redo overhead was suffered during the DELETE, not in the TRUNCATE.
Hemant K Chitale
http://hemantoracledba.blogspot.com
sent from my smartphone
>
> On Nov 23, 2010 2:30 AM, "Sheehan, Jeremy" <
JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx> wrote:
>
> Right ...
>
>
>
> -----Original Message-----
> From: Adam Musch [mailto:ahmusch@xxxxxxxxx]
Sent: Monday, November 22,...
Other related posts: