Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

When to use materialized view in Oracle DBMS?

user-image
Question ajoutée par محمد حسام الدين حسن صدقى , Senior Functional Consultant , Egabi Fsi
Date de publication: 2016/11/19
maria philip rinaldi
par maria philip rinaldi , quality exective , SNS Enterprises

Materialized View is used for replicate of data in the table

Muhammad Asif
par Muhammad Asif , Software Enigneer , Sapphire Fibres Limited

when we have a large number of record in our query. query reterive record after long time then we need to create materialized veiw to ger data speedly.

in data where house we create materialized view to get automatacelly data from client side

 

yassine zyadi
par yassine zyadi , Support Technique IT , Archcos Technology

Le rayon utilise des vues matérialisées (également appelées instantanés dans des versions antérieures) pour répliquer des données sur des sites non maîtresses dans un environnement de réplication et pour mettre en cache des requêtes coûteuses dans un environnement de stockage de données. Ce chapitre, et ce manuel de réplication Oracle9i en général, traite des vues matérialisées à utiliser dans un environnement de réplication.

Tarek Ghonamy
par Tarek Ghonamy , CTO , Trans Skills

No need to use materialized views unless you are using Oracle version less than 12c, now you have the RESULT_CACHE hint which allows you to cache the result of queries, functions, views and tables. Cautious when using this feature as a tradeoff between memory usage and  hard disk usage  have to be  weighed, ideally it should be used if the underlying table(s) of a query don't change frequently.

MOHAMMAD AKHLAKUR  RAHMAN
par MOHAMMAD AKHLAKUR RAHMAN , Baud Telecom Company

When we need to pull huge data at the certain period

belgacem lamloumi
par belgacem lamloumi , Trading Manager , G&G International Trade

You can use materialized views to achieve one or more of the following goals:

anil kumar
par anil kumar , Senior Systems Engineer , Iinfosys ltd.

materialised views are used when standard views (used to retrieve data from various tables without joins /foreign key relations) are not suggested or feasible to use.

unlike standard view we can periodically run these views as they are disk based views, but standard views generate data every time they are queried. this will result in better performance in terms of time every time we query the view.

More Questions Like This