different DOP on tables nd indexes.
We have a few tables that have a different degree of paralellism from their indexes. I read that the table and indexes should have the same degree. Is that a best practice? If so, what are the issues if the DOP is different on the tables and the indexes? Why should they be the same and what is it's effect on CBO?
I have googled and have not been able to find out why they need to be the same. Can anyone point me to any links or articles on this?