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

PLS-00583: size must be specified if opaque type is fixed-length

1 Answers  


RMAN-06437: cannot drop catalog - catalog is newer than this RMAN

1 Answers  


RMAN-06578: INCREMENTAL LEVEL > 0 must be specified with FOR RECOVER OF

1 Answers  


ORA-26525: session connection attempt failed for string (@string)

1 Answers  


EXP-00087: Problem with internal hash table of schema/table names

1 Answers  


RMAN-06585: no copy of datafile number found

1 Answers  


QSM-01013: nested aggregates or CONNECT BY/START WITH clause present

1 Answers  


this is the exception raised when i am working with oracle 11g java.lang.ClassNotFoundException: oracle.jdbc.Driver.Ora cleDriver.. but i set the class path for both oracle and java..

1 Answers  


ORA-13216: failed to update spatial index

1 Answers  


PCC-02430: Expecting an expression of some arbitrary LOB type

1 Answers  


ORA-02251: subquery not allowed here

1 Answers  


ORA-25401: can not continue fetches

1 Answers  


Categories