What is meant by Materialized view?

Question Posted / arasan500

2 Answers
7559 Views
iGate, Marlabs, Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is meant by Materialized view?..

Answer / raj&

materialized views are schema objects that can be used to summarize,precompute,replicate and distribute data.

Is This Answer Correct ?

4 Yes

1 No

What is meant by Materialized view?..

Answer / nitin

Materialized views are used to precompute a heavy joins instead of executing a joins again n again. Moreover it physically stores the data unlike views where it is conceptually. Materialized views can be refresh on timely manner.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

explain the delete statements in sql

0 Answers

What is the difference between numeric and autonumber?

0 Answers

what are the methods using performance tunning in sql and pl/sql

2 Answers

four procedures is are there should i write their in a package

2 Answers

What are types of joins?

0 Answers

how to shutdown mysql server? : Sql dba

0 Answers

Does sql view stored data?

0 Answers

what are the type of locks ? : Sql dba

0 Answers

What is replication id?

0 Answers

How do you update a value in sql?

0 Answers

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers Deloitte, Ness Technologies,

how to select unique records from a table? : Sql dba

0 Answers

For more SQL PLSQL Interview Questions Click Here