How do you use MAXDOP in a View? I have several views that are used to export data from SQL-Server into .csv files. They are all executed via SSIS packages. Our DBA has decided to set the "Max Degree of Parallelism" to 1 and told me to use MAXDOP where I think it makes sense.

I have now seen many times that MAXDOP really helps to pull big data amounts (especially when it results in a table scan over all partitions).

Questions


How can I use MAXDOP in a view ?
Is there a way around this restriction ?
You can't.

A view is a stored sub-query. MAXDOP is a query hint.