I'm trying to set MAXDOP option on a non-clustered columnstore index using the following ways and it doesn't seem to be sticking. Server is SQL Server 2019.
Index properties -> Options Page -> Maximum Degree of Parallelism. I have set this to 2 and hit OK. It doesn't show me any error but when I check the index properties again, it shows 0 for Maximum Degree of Parallelism.
ALTER INDEX IXCS_Test ON [DBTest].[TBLTest] REBUILD WITH (MAXDOP = 2)This statement executes successfully without errors but again, when I check the properties of the index it's still at 0.
After trying each the above options, I tried scripting the index as a Create statement and I don't see the MAXDOP option in the script.
What am I missing here? Please help.