Where clause and cartesian product

Hi,

Im new to databases/Oracle.

Recently I enrolled in an Oracle certification course. The Oracle course material says that usage of Where clause is preffered as it avoids a cartesian product (thus overloading the query). One colleague in the class said that even if one uses a Where clause in a SQL statement involving 2 tables, the oracle system first does a cartesian product of the 2 tables and then applies the where condition the ouput and displays it to the user (my teacher isnt sure about how it works). How does it work in reality?

regards,
Hari
India Received on Tue Dec 13 2005 - 01:01:54 CST