Why not use query rewrite function
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Why not use query rewrite function

  1. #1
    Join Date
    Nov 2004
    Posts
    2

    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
    Posts
    736

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