2

I have been slowly trying to learn MDX coming from a background of using SQL. In DBMSs such as PostgreSQL, one can get a query plan for their query e.g. using EXPLAIN. Is this possible in any version of MDX and if so, how? I have not managed to come across something of this nature.

MoazRub
  • 2,881
  • 2
  • 10
  • 20
baceda9220
  • 41
  • 1
  • 4

1 Answers1

0

Not exactly a query plan, but DMVs and profiler will be helpful. The profiler can be launched from management studio, Tools.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
MoazRub
  • 2,881
  • 2
  • 10
  • 20
  • Thanks. But I suppose DMV and profiler are very different from seeing a query plan. If such a thing does not exist here, I wonder why that would be the case? – baceda9220 Mar 03 '20 at 18:56
  • I also wonder why is that not avaliable but that does answer your question? – MoazRub Mar 03 '20 at 19:12
  • Not exactly; it helps a lot, but I was hoping for more of a discussion on this point. – baceda9220 Mar 03 '20 at 20:20
  • Exactly what is it that you are trying to achive, that you cannot without explain. MDX is very diffrent from SQL so what is it that you are looking for ? – MoazRub Mar 03 '20 at 22:54
  • 1
    I am just trying to learn what happens internally when executing MDX queries. I know with SQL that through EXPLAIN, I can see what operations will be executed, but I have absolutely no clue what is going on with MDX and I could not find much material on this topic at all. Maybe you could suggest some material on the topic? – baceda9220 Mar 04 '20 at 01:00
  • So MDX is not excuted like SQL. In an explain you get ti see where the index seek and scan happens. However MDX is not executed like that at all. You should question should be how is a typical MDX query executed. take a look at https://stackoverflow.com/questions/60454020/counting-the-number-of-facts-in-a-cell-in-mdx – MoazRub Mar 04 '20 at 11:43