Reply to thread

Message: <blockquote data-quote="DJvodka" data-source="post: 13046959" data-attributes="member: 186185"><p>I don't think we are in the same page here. I’m not talking about the client end. Let’s say you have employee, project and department tables in your DB. Departments and Employees are assigned to projects. You want to get number of projects, completed by each employee. The only way to achieve this is to use a join. But lets say you have another column called project count, in the employee table which get incremented by 1 whenever a project get completed, using a trigger, of course. Now you can directly query the new column, without joining and you can yield results more efficiently. So no extra join algorithms needed to perform, just pulling the stuff from the base table. Please note that I’m not a DB savvy or anything.<img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" /></p></blockquote><p></p>

Top Bottom