Based on how the view is constructed and the techniques that are allowed for accessing the view data, there are four sorts of views. Database Views, Projection Views, Maintenance Views, and Helps Views are the four types.
Only views with the same owner as the relevant table or tables can have indexes generated. An intact ownership-chain between the view and the table is also known as this (s). When a table and a view are both part of the same schema, the same schema-owner applies to all of the schema's objects.
Views have a benefit over tables in that they can represent a subset of the data in a table. As a result, a view can limit the extent to which the underlying tables are exposed to the outside world: a user may be allowed to query the view but not the remainder of the base database.
SQL Server examines the code in the view BEFORE dealing with the WHERE clause or any joins in the outer query when processing a SELECT from a view. When more tables are combined, it will take longer to get the same results as a SELECT from base tables.
Views make it easier to create queries, but they don't increase query performance.
Learner's Ratings
4.3
Overall Rating
69%
12%
8%
0%
11%
Reviews
R
ruhina qureshi
5
Awesome Classes ,Both tutors explains the concept very nice
Y
Yadav Aakash
5
very useful thank you learnvern
A
Ashish
5
The course is very good. I have stuck at a point that how you create multiple rows with a single insert in sales.customer table. I get only one customer data. this table is related to bikestore data.
N
nayazbasha sk
5
very useful thank you learnvern
M
Mahima Patel
5
very usefull......thanks
P
Priya Kushwaha
5
Very Good trainer
C
chanchal singh
5
you guys are doing nice job. thanks
U
Umesh Wankhede
5
Not too much interactive
M
Monesh Ram
5
Well Explained in Every Chapters..
G
GAJANAN DIGAMBAR MODE
5
very easy to understand SQL its was dream to learn SQL. Thanx for Learnvern
Share a personalized message with your friends.