DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Question Why not use query rewrite function

    We use oracle9i standard version.
    I create a MV with same Select sql as a existing view.
    When I set a session with parameters QUERY_REWRITE_ENABLED=TRUE
    and try to run "select * from existing_view"
    Then I get same explain before I create MV.
    Why it not use query rewrite function?

  2. #2
    Join Date
    May 2001

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.