1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Explain materialized views and how they are used.

Question Posted / guest


Explain materialized views and how they are used...

Answer / Alok Gautam

Materialized views (MVs) are precomputed and stored snapshots of query results in a database. They allow for faster query performance when accessing data that is frequently requested, as the computationally-intensive work of generating the result set has already been done.nnFor example, a materialized view can be created to summarize large amounts of data, such as total sales by region or product category. This can greatly improve query response times, especially for complex queries that involve aggregating large datasets.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

Why would you use sql agent? : sql server DBA

1 Answers  

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

what is ora 24313?what is the procedure to exclude that error?

1 Answers  

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

What is a correlated sub-query? : sql server DBA

1 Answers  

why we use cursors

1 Answers  

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

1 Answers  

For more DB Administration Interview Questions Click Here
Categories