DRG-10535: failed to optimize text index string

DRG-51313: timeout while waiting for DML or optimize lock

ORA-01986: OPTIMIZER_GOAL is obsolete

ORA-02022: remote statement has unoptimized view with remote object

ORA-04940: unsupported optimization of Oracle binary, check alert log for more info

QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based

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

What is rule base and cost base optimizer?

Thermotech,

what is mapping optimization? wat are the techniques for tat

how to optimize the query perfomance in b.o?

TCS,

what is query optimizer? what are different types of optimizer s supported by oracle ?

ABC,

what is integration,optimization of gsm corenetwork in practice?

Ericsson,

What is Query Execution Plan? How does it help optimize or tune a database driven application?

Accenture, Polaris,

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

how will optimiz the performance of sql in FM ?

Infosys,