Interested to Buy Any Domain ? << Click Here >> for more details...
What is Materialized View? In What Scenario we Use
Materialized View?
- 2 Answers
- 9400 Views
- Dinesh, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / chandan kumar
The above answer is right till here....view is a virtual
table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also
same
like the view but it exist in rdbms.
We use the Materialized View in that Senerio when we have
large amount of database and we need to refresh that in a
time being.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Can delete statement be rollbacked?
What is a delimiter in sas?
What is an oracle stored procedure?
Which is faster truncate or drop?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is the usage of when clause in trigger?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How can triggers be used for the table auditing?
Which are the different types of indexes in sql?
Can we use loop in sql?
What normalization means?
Explain what is a column in a table?
Define join and name different types of joins?
Can we delete column in sql?
what is the syntax for using sql_variant_property? : Transact sql
