Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Cartesian Product

Cartesian Product

From: Lonnie <lonnie2000_at_atl.mediaone.net>
Date: Mon, 19 Nov 2001 17:53:50 GMT
Message-ID: <OGbK7.7115$gr6.2627607@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?
  2. What would a Cartesian Product statement do to the database if the two tables had 300,000 rows in each table?
--

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US