Web Technologies
Cloud/DevOps Technologies
Latest Technologies
Ask a Question

What is the difference between View and Materialized View?

0 votes
in Dataware house by (23.1k points)
What is the difference between View and Materialized View?

1 Answer

0 votes
by (30.6k points)

A view is nothing but a virtual table which takes the output of the query and it can be used in place of tables.

A materialized view is nothing but an indirect access to the table data by storing the results of a query in a separate schema.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
How do we use the materialized view?
asked Mar 25 in Oracle by john ganales (13.0k points)
0 votes
What is the difference between metadata and data dictionary?
asked Oct 20, 2019 in Dataware house by rajeshsharma (23.1k points)
0 votes
What is the difference between OLTP and OLAP?
asked Oct 20, 2019 in Dataware house by rajeshsharma (23.1k points)
0 votes
Explain what is the difference between View and Partial View?
asked May 15, 2020 in MVC Language by sharadyadav1986 (30.4k points)

Top Trending Technologies Interview Questions and Answers

Agile Questions & Answers
Javascript Questions & Answers
Ansible Questions & Answers
Bootstrap Questions & Answers
Angular Questions & Answers
Android Questions & Answers
Linux Questions & Answers
Kibana Questions & Answers
Dataware Questions & Answers
Gradle Questions & Answers
Bitcoin Questions & Answers
Cassandra Questions & Answers
ABBYY-FlexiCapture Questions & Answers
Statistics & Probability Questions & Answers
Amazon Database Questions & Answers
Amazon Elastic Questions & Answers
Amazon Neptune Questions & Answers
Amazon Storage Questions & Answers
Amazon S3 Glacier Questions & Answers
JIRA Questions & Answers
Azure Questions & Answers
Blockchain Questions & Answers
GIT Questions & Answers
DOT NET Questions & Answers
Growth & Transformation Questions Answers
Keycloak Questions & Answers
5G-Network Questions & Answers
AWS Questions & Answers
C# Questions & Answers
C++ Interview Questions & Answers
REACTJS Questions & Answers
AJAX Questions & Answers
Data Handling Questions & Answers
Hadoop Questions & Answers
Big Data Questions & Answers
HTML Questions & Answers
JAVA Questions & Answers
JavaScript Questions & Answers
Apache Druid Questions & Answers
Apache Phoenix Questions & Answers
Apache Pig Questions & Answers
Apache Storm Questions & Answers
AWS Codecommit Questions & Answers
AWS Essentials Questions & Answers
Cache Techniques Questions & Answers
Machine Learning Questions & Answers
MVC Language Questions & Answers
NOSQL Questions & Answers
Python Questions & Answers
R Language Questions & Answers
End Point Security Questions & Answers
Fortify Code Scanner Questions & Answers
Framework Questions & Answers
IONIC Questions & Answers
Cyber Security Questions & Answers
Data Mining Methods Questions & Answers
Devops Security Questions & Answers
Cloud Questions & Answers
Salesforce Questions & Answers
Selenium Questions & Answers
Spark SQL Questions & Answers
VUE JS Questions & Answers
Devops Questions & Answers
Jenkins Questions & Answers
Artificial Intelligence Questions & Answers
Continuous Integration Questions & Answers
GIT Questions & Answers
Continuous Deployment Questions & Answers
Cyber Security Questions & Answers
Memcached Questions & Answers
Sequence Models Questions & Answers
Tableau Questions & Answers
Typography Questions & Answers
Usability Principles Questions & Answers
Xamarin Questions & Answers
User Research Method Questions & Answers
About us

HOT LINKS

NO SQL/MangoDB

Data Visualisation Aurora

DevOps

Javascript

Hadoop and Big Data

JAVA

TRANDING TECHNOLOGIES

Agile and SAFE

DevOps

Spark SQL

Git

Service Now

Arduino

CONTACT US

New York, NY 10012, US

[email protected]

Follow us on Social Media


© Copyright 2018-2023 www.madanswer.com. All rights reserved. Developed by Madanswer.

...