Post reply

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

  • May 12, 2022 at 10:14 am

    #4031711

    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.

  • May 12, 2022 at 12:44 pm

    #4031760

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

  • May 13, 2022 at 3:45 am

    #4032167

    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.

  • May 13, 2022 at 1:04 pm

    #4032404

    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 3 (of 3 total)

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