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

RMAN-06466: error parsing configuration string (string)

1 Answers  


SQL*Loader-00608: subpartition not empty for INSERT option; table string, subpartition string

1 Answers  


KUP-04047: error parsing record from external data source

1 Answers  


RMAN-08002: starting full resync of recovery catalog

1 Answers  


ORA-30725: JDWP-based debugging is not yet available

1 Answers  


RMAN-08070: deleted datafile copy

1 Answers  


ORA-14457: disallowed Nested Table column in a Temporary table

1 Answers  


PCC-00095: Missing PROGRAM, SUBROUTINE, FUNCTION, or BLOCK DATA statement

1 Answers  


ORA-01754: a table may contain only one column of type LONG

1 Answers  


RMAN-08042: channel string: copied standby controlfile

1 Answers  


ORA-00329: archived log begins at change string, need change string

1 Answers  


RMAN-06432: recovery catalog dropped

1 Answers  


Categories