Materialized View with complex condition

[ckwan]

Hello Everyone,
I have a difficulties on creating Materialied View which involved of multiple tables and multiple complex select statement.
And those based tables are very huge records of data.

The more joins on the tables, the longer creatoion time it is.

What is the best way to deal with this ? Appreciate for any valueable feedback.

Thanks

[mike9]

Execute your query without creating the MV, have a look at the explain plan and try to optimise it.