use of option(maxdop 8) in query binding of SSAS cube

  • Hi All

    Has anyone used table hint in query binding of SSAS. I need to add it for performance reasons but I get syntax error. Seems it is not allowed to add table hints in query binding.

    If anyone has any workaround figured, pls do let me know.

    thanks

    Suresh

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • Your best option would probably be to create a view (with the table hint), and then use that in SSAS.

  • Martin, that would have been the best option, but unfortunately views doesn't allow table hints.

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • True, I see you can only use table hints and not query hints. why are you trying to enforce the parallelism?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply