What is the differnce between view and materialized view
Answers were Sorted based on User's Feedback
Answer / nivedita
view is a virtual table.view does not contain any data
while material view has its own data.material views are the
local copies of remote data.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / yaswanth
A view will takes the output of the query. But a materialized
view stores the output of the query which is not possible in
view
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / suresh babu
View:view is a logical table,it don't have own data,the
query which we mentioned after the create view statement
will be compiled and stored in server as a database
object.once we call the view,the compiled query will be
fetch the data from master table.
The DML operations will be reflected in master table or
view suddenly.
Materialized view:The Materialized view required physical
memory space.it will be created from target master
table,which located in some other location.A materialized
view can be created either single mater table or multimater
tables from multiple master sites.the changes which we have
done in master table will reflect in particular interval
time.the materialized view,which created from multiple
master tables,will updated its individual batch files....
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / papia
view does not contain actual data but MV contains data.MV
needs to be refereshed after a particular interval.Bit when
a view is queried it actually queries the underlying tables.
Is This Answer Correct ? | 1 Yes | 0 No |
What is a trigger in pl/sql?
What are the different dml commands in sql?
Why we use cross join?
How do I filter in sql profiler?
What company owns postgresql?
When you have to use a default "rollback to" savepoint of plvlog?
Can ddl statements be used in pl/sql?
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.
How can I tell if sql is running?
Why do we use function in pl sql?
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent
Is sql easier than java?