<div dir="ltr">Hello Arvind,<div><br></div><div>We've been discussing merging the segment and tuple queries for some time now, but their separation is at the core of the algorithm which resolves a query into its result. It isn't a trivial matter to merge the two together, and so far it hasn't happened.</div>
<div><br></div><div>As for the tuple queries using the fact table, this usually happens when an MDX statement asks for the non empty tuples. In that situation, we join through the fact table and voila. If the crossjoin is simple enough, the fact table should be omitted from the query.</div>
<div><br></div><div>Luc</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jan 30, 2014 at 2:42 AM, Arvindkumar J <span dir="ltr"><<a href="mailto:j.arvindkumar@gmail.com" target="_blank">j.arvindkumar@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_quote"><div dir="ltr"><div><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">Hi All, </span></div>
<div><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif"><br>
</span></div><div><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">I have a query regarding SQL query generation. </span></div><div><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif"><br>
</span></div><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">For each MDX query, mondrian fires set of readTuple queries and segment.load queries. </span><br style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">
<span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">I understand that readTuple queries are used to populate the axes and segment load queries to populate the cell values. So usually there are more readTuple queries compared to segment.load queries.</span><br style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">
<br style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif"><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">Why can't we avoid the readTuple queries in case where the predicates are fixed ? </span><div>
<span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">(i know we can't avoid in-case the predicates are like </span><code style="line-height:16.875px">[Product].children</code><span style="line-height:16.875px;font-family:Arial,Helvetica,sans-serif"> </span><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">). </span><br style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">
<span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">Instead, we can populate the axes from the input predicates and filtering of tuples with 0 values can be doneter the segment load queries. </span><br style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">
</div><div><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif"><br></span></div><div><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif">The reason i'm asking this is the readTuple queries are taking major part of the query time. And i notice these queries are on fact tables. Are these queries supposed to be on fact tables or only dimension tables ?</span></div>
<div><span style="font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif"><br></span></div><div><font face="Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif">Please correct me if my understanding is not correct. </font></div>
<div><font face="Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif"><br></font></div><div><font face="Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif">Thanks</font></div><div><font face="Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif">Arvind</font></div>
</div>
</div><br></div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br></div>