Page 1 of 1
Index Rebuild option
Posted: Fri Sep 21, 2007 12:52 am
by raji
Hi,
In paralle we have the index rebuild option.
Like wise whats the equivalent option in Server jobs.
Will anyone please give me a suggestion ?
Regards,
Raji
Posted: Fri Sep 21, 2007 4:51 am
by ray.wurlod
Indexes, and the rebuilding thereof, is associated with the Repository in which ALL job types (and other objects, such as Routines) are stored. Therefore, there is no different way to do it for server jobs versus parallel jobs.
Posted: Fri Sep 21, 2007 5:47 am
by ameyvaidya
I suspect that this post is about the Oracle Enterprise stage in PX VS the Oracle load stages in Server?
Posted: Fri Sep 21, 2007 7:17 am
by chulett
As do I. Server has no such automatic option. You would, instead, need to code something equivalent 'after sql' or in some manner of separate step.