-
Hi,
I've got a problem to use query rewrite with a materialized view I created.
When I write a query which is different than the query of the materialized view, the execution doesn't use the materialized view but the tables.
My database is in choose mode, and I have the 'enabled_query_rewrite=true' in the init.ora file.
What should I do?
-
grant QUERY REWRITE
grant GLOBAL QUERY REWRITE
-
I've evere tried it but it didn't solved my problem
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|