Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


QSM-01022: a more optimal materialized view than string was
used to rewrite



QSM-01022: a more optimal materialized view than string was used to rewrite..

Answer / guest

Cause: Query Rewrite always chooses the most optimal
materialized view based on certain parameters, such as
cardinality of the materialized view, number of joins etc.
The materialized view specified was found to be less optimal.

Action: To force using a materialized view, consider using a
rewrite hint.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01060: illegal subquery in the HAVING clause

1 Answers  


ORA-29283: invalid file operation

1 Answers  


ORA-12045: invalid ALTER MATERIALIZED VIEW LOG option

1 Answers  


PLS-00717: method 'string' does not have matching signature among existing methods

1 Answers  


TNS-00544: unsupported operation

1 Answers  


RMAN-06449: deleted proxy copy

1 Answers  


ORA-19707: invalid record block number - string

1 Answers  


PCC-02341: host variable has illegal type

1 Answers  


NNO-00070: administrative region has changed, reloading domain data

1 Answers  


NNL-00306: Server setting all statistic counters to zero

1 Answers  


DRG-10309: not enough job queue processes

1 Answers  


LFI-01507: fwrite() failed(OSD return value = string) in string.

1 Answers  


Categories