informer30
MIS
Hi All,
can some one tell me in simple terms what is a cartesian product?
Many Thanks
can some one tell me in simple terms what is a cartesian product?
Many Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cartesian Product
- Thread starter informer30
- Start date
- Status
IanWaterman
Programmer
Its when you have two or more tables and you do not join them. You then get a relationship for every permutation of the records.
ie if you have two tables with 100 records in each, the cartesian product would yield a dataset of
100 x 100 = 10,000
Generally not considered to be very useful ;-)
Ian
ie if you have two tables with 100 records in each, the cartesian product would yield a dataset of
100 x 100 = 10,000
Generally not considered to be very useful ;-)
Ian
- Thread starter
- #3
informer30
MIS
does this only happen when the no join? e.g. you have 2 tables and they are no joined...?
- Thread starter
- #5
informer30
MIS
the other part i dont understand if the 2 tables have a combined total of 200 records....what are the other 800 showing?
Many Thanks
Ps. sorry if these are silly questions...
Many Thanks
Ps. sorry if these are silly questions...
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question