Home » Developer & Programmer » Data Integration » Problems with query rewrite and materialized views
Problems with query rewrite and materialized views [message #92977] Fri, 05 July 2002 04:47 Go to next message
Seb
Messages: 7
Registered: July 2000
Junior Member
Hello,
I've got an enormous problem to use the query rewrite possibilities of Oracle 8.1.5.
My database is parametred in choose mode with enabled_query_rewrite=true in the init.ora file.
I've created a materialized view. But, if I don't use exactly the same query than the query I used to create my mv, the execution doesn't use the mv but the tables.
Help!!!!!!!! What must I do?
Re: Problems with query rewrite and materialized views [message #92982 is a reply to message #92977] Thu, 11 July 2002 07:00 Go to previous messageGo to next message
Piotrek
Messages: 4
Registered: July 2002
Junior Member
upgrade to 8.1.7
Re: Problems with query rewrite and materialized views [message #93136 is a reply to message #92977] Wed, 05 March 2003 12:26 Go to previous message
Whatever
Messages: 1
Registered: March 2003
Junior Member
create (bitmap) indexes on the columns of the MV.
I did it and mine work now.

Cheers.
Previous Topic: Oralce 9i
Next Topic: Data Warehousing Project - Consultants Needed
Goto Forum:
  


Current Time: Thu Aug 06 11:50:16 CDT 2020