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

ORA-06001: NETASY: port set-up failure

1 Answers  


PCC-02152: Unable to open file string to display or list the source line number

1 Answers  


DRG-11108: invalid filename specified: string

1 Answers  


PROC-00023: Error in cluster services layer

1 Answers  


ORA-16126: loading table or sequence string

1 Answers  


RMAN-08097: channel string: starting validation of archive log backupset

1 Answers  


ORA-22292: Cannot open a LOB in read-write mode without a transaction

1 Answers  


RMAN-06534: KEEP ... CONSISTENT option is not supported

1 Answers  


ORA-34901: (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.

1 Answers  


EXP-00063: error in changing language handle

1 Answers  


ORA-38959: Failed to update block 0 to new version 10 format

1 Answers  


ORA-02288: invalid OPEN mode

1 Answers  


Categories