Answer / raj&

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

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.

what is a relationship and what are they? : Sql dba

0 Answers  

---

how to check server status with 'mysqladmin'? : Sql dba

0 Answers  

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---

What are conditional predicates?

0 Answers  

---

What is the use of time stamp in select statement?

1 Answers   TCS,

---

---

What are different types of sql commands?

0 Answers  

---

what are the 'mysql' command line options? : Sql dba

0 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

How do you write an index?

0 Answers  

---

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

---

What is a rank in sql?

0 Answers  

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---