Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - True or False (Q.No. 8)
8.
A dynamic view is one whose contents materialize when referenced.
Discussion:
4 comments Page 1 of 1.
Sathvik reddy said:
9 years ago
Please explain in detail how the above statement is true?
Avinash said:
1 decade ago
A view is virtual table but when we use schema binding in the creation of view then it'll make materialize view for example:
Create view VW Total Sales By Product.
With Schema Binding.
Select Name,
SUM (ISNULL((QuantitySold * UnitPrice), 0)) as Total Sales,
COUNT_BIG (*) as Total Transactions.
From dbo.tblProductSales.
Join dbo.tblProduct.
On dbo.tblProduct.ProductId = dbo.tblProductSales.ProductId.
Group by Name:
After that it have its own data and it make a reference with related table.
Create view VW Total Sales By Product.
With Schema Binding.
Select Name,
SUM (ISNULL((QuantitySold * UnitPrice), 0)) as Total Sales,
COUNT_BIG (*) as Total Transactions.
From dbo.tblProductSales.
Join dbo.tblProduct.
On dbo.tblProduct.ProductId = dbo.tblProductSales.ProductId.
Group by Name:
After that it have its own data and it make a reference with related table.
Singh said:
1 decade ago
Dynamic view is a view which continuously updated while a database is open and in use.
Vino said:
1 decade ago
What is dynamic view? and what is materialization?
Can anybody help?
Can anybody help?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers