SQL Server Performance

Cartesian Product between tables

Discussion in 'Getting Started' started by RVG, Jan 20, 2010.

  1. RVG Member

    Hi,
    at what time the cartesian product between the tables can occur explain this please.
    Thanks &Regards,
    Ravi Varma.
  2. Adriaan New Member

    Class room excercise?
  3. FrankKalis Moderator

    You may want to look up CROSS JOIN in Books Online. There is also a difference between logical & physical query processing, but I doubt that your question is amied at this level.

Share This Page