SQL SERVER 2008 – What is a Cartesian product and What causes it

A Cartesian product is the result of an unrestricted join of two or more tables. The result set of a three table Cartesian product will have x * y * z number of rows where x, y, z correspond to the number of rows in each table involved in the join. It is causes by specifying a table in the FROM clause without joining it to another table.

Reference : Dilip Kumar Jena ( https://sqlexplore.wordpress.com )

Advertisements

2 thoughts on “SQL SERVER 2008 – What is a Cartesian product and What causes it

  1. Thank you for article. I think that a post is interesting . I like your article this site. I need to know how can I subscribe to your blog?. I will be follow you blog each 9 days.

    • if you really wish to Subscribe there are many option

      First : You can see a button RssFeeds under MSTechExplore Clicks click on it and choose ur reader or caan Subscribe thorough email.

      Second : Email Subscription click on sign me up and provide your email and u will get emails from wordpress.com about my posts when they are posted .

      Choice is all yours happy reading.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s