Page Comparison

SELECT *
FROM 
  (SELECT CACHE_ENABLE(FALSE) FROM DUAL) //-- (1) Cache disabled
[LEFT] JOIN //-- (2) Left Join might be required to force the irght execution order -> Disabling cache first
  ISSUES i ON  i.ID = 10000 //-- (3) Moving the conditions from the WHERE caluse as a JOIN constraint may resolve issues
JOIN 
  ISSUETYPES it on it.ID = i.TYPEID