materialized views in Oracle 9

Hi,

I want to use materialized views to speed up my queries. To check if it is working I used the query I want to accelerate in the statement to create the m-view.

example:
Query to accelerate:

   SELECT * FROM student, person
   WHERE s_ID=p_ID

      AND s_sex='female';

m-view definition:
CREATE MATERIALIZED VIEW Anfr23_MV AS

   SELECT * FROM student, person
   WHERE s_ID=p_ID

      AND s_sex='female';

Unfortunately the view did not help to speed up the query. Furthermore the execution plan did not mention the m-view.

What is my mistake?
Thanks for any help.
Best regards,
Michel Received on Fri Feb 06 2004 - 12:55:39 CST