Re: Cartesian Product

"Lonnie" <lonnie2000_at_atl.mediaone.net> wrote in message news:OGbK7.7115$gr6.2627607_at_typhoon.jacksonville.mediaone.net...
> 1. What would happen if the two tables that we were
> joining had 300,000 records in each table. What would
> be the total number of rows returned?
>

Depends upon how many match the join. e.g. no matches then no rows. 1 match 1 row.

> 2. What would a Cartesian Product statement do to the
> database if the two tables had 300,000 rows in each
> table?
>

The first row from table 1 would be matched with 300,000 rows in table 2 and then row 2 in table 1 would be matched with 300,000 rows in table 2... 300,000^2

>
> --
> *******************************************
> "The World Steps Aside For Any Woman Who Knows Where She's Going....no
ways
> tired"
> *******************************************
>
>
Received on Mon Nov 19 2001 - 12:25:50 CST