QSM-01091: cost based optimizer found query rewrite is more
expensive



QSM-01091: cost based optimizer found query rewrite is more expensive..

Answer / guest

Cause: When cost based optimizer is ON, cost of the
rewritten cursor is compared to the cursor generated without
query rewrite, and the cheaper one is chosen for execution.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09838: removeCallback: failure removing the callback port.

1 Answers  


EXP-00068: tablespace string is offline

1 Answers  


DRG-50937: query too complex

1 Answers  


SQL*Loader-00643: error executing INSERT statement for table string

1 Answers  


PLS-01422: Aliases

1 Answers  






TNS-00537: Index into protocol adapter table is out of legal range

1 Answers  


ORA-01915: invalid auditing option for views

1 Answers  


LSX-00009: data missing for type "~S"

1 Answers  


ORA-08101: index key does not exist file string: (root string, node string) blocks (string)

1 Answers  


NNL-00274: server not started, errors follow

1 Answers  


TNS-00038: INTCTL: Poorly formed address or command string

1 Answers  


RMAN-08180: channel string: restore complete, elapsed time: string

1 Answers  


Categories