Comments
Sort by recent activity
Chris Auckland wrote:
I think I follow. If you don't specify NOPARALLEL then the index after the alter keeps the original PARALLEL setting.
I'll test that out and report a bug if that's the case.
Thanks for the clarification.
Actually - the alter statement given by the tool "ALTER INDEX fake_index_name ;" is simply not a valid DDL statement... you need the NOPARALLEL in there... / comments
Chris Auckland wrote:
I think I follow. If you don't specify NOPARALLEL then the index after the alter keeps the original PARALLEL setting.
I'll test that out and report a bug if that's the case...
Thanks for the reply, Chris. So, the issue is actually when I want to remove parallel from a given instance. For example, I compare schema A to schema B - schema A has a Parallel of 4 for index named fake_index_name, schema B has no parallel setup for the same index. I want to make fake_index_name in schema A look exactly like schema B, meaning I need to drop the parallel from the index. In this case, the tool provides "ALTER INDEX fake_index_name ;" when it should provide "ALTER INDEX fake_index_name NOPARALLEL;"
Hope this makes sense? / comments
Thanks for the reply, Chris. So, the issue is actually when I want to remove parallel from a given instance. For example, I compare schema A to schema B - schema A has a Parallel of 4 for index n...