Details
-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
None
-
None
Description
Sample models are attached. User query is:
SELECT * FROM v_TV_SHOWS.v_SHOWS_ACTORS2
WHERE SHOW_NAME LIKE '%E%' AND
NOT ACTOR_SHOW_ID IN (SELECT ACTOR_SHOW_ID FROM v_TV_SHOWS.v_SHOWS_ACTORS2 WHERE ACTOR_NAME = 'MALCOLM JAMAL-WARNER')
OPTION DEBUG and MMProcess.log are attached.
Customer complaint is that the query contains criteria on ACTOR_NAME and ACTOR_SHOW_ID which is coming from Oracle and on SHOW_NAME which is coming from SQL Server. In the query plan, there is a SELECT node that does not have criteria to Oracle. Instead it is SELECT * which pulls all records. Customer tables are huge so this is an issue for them.