Re: Cartesian product - wrong result
Sorry for my previous comment, maybe there is a join condition which I missed earlier, I hope this is the correct join condition
MID(d.data_site,3,3) = c.customer_short
If that the case an index on c.customer_short may helps, maybe even a unique index, I expect it to be unique since it must be able to identify a customer with this field, since it is being used as a join column to match the rows in table d.
data_starttime is from table d, right?
Index this as well.
Subject
Views
Written By
Posted
3081
October 31, 2005 08:38AM
1395
October 31, 2005 09:04AM
1340
November 01, 2005 08:01PM
1367
November 02, 2005 01:42AM
Re: Cartesian product - wrong result
1372
November 03, 2005 08:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.