Interested to Buy Any Domain ? << Click Here >> for more details...
What is the differnce between view and materialized view
- 4 Answers
- 8988 Views
- TCS, I also Faced
- E-Mail Answers
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 bcp? When is it used?
How many types of index are there?
How do you modify a trigger?
what is an extent ? : Sql dba
What is sqlservr exe?
Why do we use cursors?
Can you skip header records while loading? : aql loader
what are the differences between char and nchar? : Sql dba
What is difference between table and view?
What is audit logout in sql profiler?
How can you select unique records from a table?
SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
