|
|
|
|
|
|
by chris_wot
5154 days ago
|
|
|
If you want to see something hilarious, get a 12 join query and add "AND 1=0" on the end of the WHERE clause. Oracle doesn't look at the query and immediately return no rows, instead the optimizer continues to generate a full plan. Apparently, according to Oracle support, they have no intention of finding "AND false" predicates to shortcut query plan compilation. |
|
|