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

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

Question Posted / guest

1 Answers
3533 Views
I also Faced
E-Mail Answers

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

NZE-29032: The given identity is not complete.

1 Answers

ORA-12554: TNS:current operation is still in progress

1 Answers

ORA-13461: the interleaving type is not supported

1 Answers

LSX-00245: invalid ID "~S"

1 Answers

PCC-02347: PL/SQL found syntax errors

1 Answers

TNS-01204: Unprivileged account (string) is in dba group (string)

1 Answers

ORA-13865: Module name must be specified

1 Answers

ORA-06914: CMX: unexepected event during start of oracle

1 Answers

SQL*Loader-00290: PIECED keyword (on column string) allowed only for lob or long columns

1 Answers

ORA-22620: buffer size too small to hold the value

1 Answers

ORA-31494: could not activate a LogMiner session

1 Answers

ORA-15116: invalid combination of ALTER DISKGROUP options

1 Answers

For more Oracle Errors Interview Questions Click Here