Interested to Buy Any Domain ? << Click Here >> for more details...
What is Materialized View? In What Scenario we Use
Materialized View?
- 2 Answers
- 9620 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
How to select 10 records from a table?
What is the maximum rows in csv?
What is the use of prepared statement?
What is server name sql?
Is sql open source?
how many sql ddl commands are supported by 'mysql'? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How many tables can a sql database have?
what is a field in a database ? : Sql dba
What is full join in sql?
What is pl sql and why it is used for?
What is rowid in sql?
How do I make my sql query run faster?
What does pragma mean?
