Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-06925: CMX: disconnect during connect request

1 Answers  


ORA-01693: max # extents (string) reached in lob segment string.string

1 Answers  


ORA-19204: Non-scalar value 'string' is marked as XML attribute

1 Answers  


ORA-10618: Operation not allowed on this segment

1 Answers  


ORA-09924: Can't spawn process - core dump directory not created properly

1 Answers  






ORA-01543: tablespace 'string' already exists

1 Answers  


ORA-19924: there are no row with id string

1 Answers  


ORA-30445: workload queries not found

1 Answers  


ORA-25405: transaction status unknown

1 Answers  


LSX-00014: empty instance document

1 Answers  


ORA-01422: exact fetch returns more than requested number of rows

1 Answers  


SQL*Loader-00131: Invalid multithreading option

1 Answers  






Categories