I've a query like this :
a.indid=b.indid and b.tel='B' and
a.indid=c.indid and c.tel='C' and
a.indid=d.indid and d.tel='D'
The master table has 100 millions of data.
Now if ind_phone table has 600 millions of data with
200 millions of data when tel='B'
200 millions of data when tel='C'
200 millions of data when tel='D'
Then what will be the cartesian product of this query?
I mean is it 100*200*200*200
Will Oracle go first to where clause then go for cartesian product ?
or Will it go first to cartesian product then it will go for where clause ?