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-13408: invalid blockSize storage parameter

1 Answers  


ORA-02050: transaction string rolled back, some remote DBs may be in-doubt

1 Answers  


DRG-11006: invalid alter index parameter string

1 Answers  


NNL-00517: Insert-replaces a data item under an existing name

1 Answers  


ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB data exists

1 Answers  


NNL-00213: No entry with specified index number, try "SHOW SYSTEM_QUERIES"

1 Answers  


ORA-24094: invalid transformation, target type does not match that of the queue

1 Answers  


PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses

1 Answers  


RMAN-06020: connected to auxiliary database (not started)

1 Answers  


ORA-32606: missing NAV keyword in MODEL clause

1 Answers  


PCB-00318: ARRAYLEN is an Oracle extension

1 Answers  


PROT-00006: The specified import file cannot be found

1 Answers  


Categories