Thanks for the link. The docs specify how to check
if query rewrite occured and if so on _which_ MV, not the _exact_ rewritten
query. I already deduced from the dbms_mview.explain_rewrite and 10046 trace
that the MV_base_table is being selected; what I wanted to find out was what was
the query on that MV - was it "select sum(totrows) from MV_base_table" or
"select count(*) from MV_base_table". I suspect the latter but can't prove it
without a trace.
|
Title: Message
- Re: Event to show Query Rewrite Darrell Landrum
- Event to show Query Rewrite Arup Nanda
- RE: Event to show Query Rewrite Seefelt, Beth
- Arup Nanda