Re: why must i specify an index in query?
If it needs to read data from the table, and Left Join requires that it read all rows, it may decide the index isn't worth it.
We could chase down the complexities of the original convoluted query, but we'd need Show Create Table results for usersmobile as well as enough Inserts for each table to replicate the problem.
Subject
Views
Written By
Posted
1919
July 02, 2015 10:31AM
972
July 02, 2015 11:46AM
1642
July 02, 2015 12:46PM
1152
July 02, 2015 01:58PM
1095
July 02, 2015 02:49PM
1052
July 02, 2015 09:47PM
994
July 02, 2015 10:36PM
1153
July 03, 2015 08:10AM
Re: why must i specify an index in query?
1040
July 03, 2015 03:06PM
1003
July 03, 2015 09:12PM
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.