Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Explain Materialized Views And How They Are Used ?
Home
PL/SQL
Explain Materialized Views And How They Are Used ?
+1
vote
asked
Mar 8, 2021
in
PL/SQL
by
sharadyadav1986
Explain Materialized Views And How They Are Used ?
#materialized-views
plsql-materialized-view
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Mar 8, 2021
by
sharadyadav1986
Materialized views are objects that are reduced sets of information that have been summarized, grouped, or aggregated from base tables. They are typically used in data warehouse or decision support systems.
Related questions
+1
vote
Q: What Background Process Refreshes Materialized Views?
asked
Mar 8, 2021
in
PL/SQL
by
sharadyadav1986
#background-process
materialized-views
plsql
0
votes
Q: Materialized views stores the data and you can refresh it on timely bases
asked
Mar 18, 2023
in
Oracle
by
GeorgeBell
oracle-interview-questions-answers
0
votes
Q: What are the best practices of creating materialized views?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
Q: What are the limitations of materialized views?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
Q: Explain what are Open, Fetch, And Close Cursor Commands? Are They Used With The Implicit Or Explicit Cursor?
asked
Mar 11, 2021
in
PL/SQL
by
Robindeniel
#open
fetch-command
cursor-command
implicit-cursor
explicit-cursor
0
votes
Q: What is the distribution of materialized views?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
materialized-views
netezza
0
votes
Q: What is the use of creating materialized views?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
materialized-views
0
votes
Q: Explain what are Transaction Control Statements? Can They Be Used Within The Pl/sql Block?
asked
Mar 11, 2021
in
PL/SQL
by
Robindeniel
#transaction-control-statement
plsql-block
plsql
0
votes
Q: What is View Group in Android? and how they are different from views?
asked
Jun 23, 2020
in
JQuery
by
AdilsonLima
#android
0
votes
Q: Explain what are Sqlcode And Sqlerrm And Why Are They Important For Pl/sql Developers?
asked
Mar 7, 2021
in
PL/SQL
by
SakshiSharma
#sqlcode
sqlerrm
plsql-developers
...