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

NZE-29103: Cannot create PKCS #12 wallet.

1 Answers  


DRG-11435: primary key value is invalid

1 Answers  


ORA-13009: the specified date string is invalid

1 Answers  


ORA-31071: Invalid database username or GUID string

1 Answers  


ORA-26022: index string.string was made unusable due to:

1 Answers  


ORA-02297: cannot disable constraint (string.string) - dependencies exist

1 Answers  


ORA-07445: exception encountered: core dump [string] [string] [string] [string] [string] [string]

1 Answers  


ORA-07432: unable to perform nested sleep

1 Answers  


PLS-00548: invalid use of operator.

1 Answers  


DRG-11829: Gone

1 Answers  


SQL*Loader-00624: no terminator found after TERMINATED and ENCLOSED field

2 Answers  


SQL-02117: Invalid SQL Cursor usage: trying to OPEN an OPENed cursor

1 Answers  


Categories