I have a decode statement that makes the table's columns have matching values. The problem is, I have 2 queries that run in about 30 seconds each. However, when I join the tables and create a single SQL statement the query takes over 10 minutes before I cancel it! Could a non- primary key /...
I have 2 Oracle 8i tables with about 15 columns each. I want to join these tables, but there is no relationship.
Can I just join the tables on like columns?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.