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
3.8
Overall Rating
44%
20%
13%
10%
13%
Reviews
K
Khushi Kumari Yadav
5
how can i get pdf of this session
A
Arvind Kumar
5
very nice course for begginer to under stand
H
hemant
5
Hello sir, explaination is excellent. I have a request please send the db in excel or SQL file
J
Juboraj Juboraj
4
Explain details & easy to understand.
A
Aman Kanaujia
4
All good , but provide the data also for the assignment , Without data the interest is less day by day from the course. So, try to solve this problem as asap.
S
Snehil
4
Everything is good but keyboard sounds more harsh and overlap your voice whereas this course is best.
F
FAROOK MOHAMMAD
5
Hello sir, explaination is excellent. I have a request please send the db in excel or SQL file.
H
Hari Prakash
4
In SQL Join Function's 2nd video - Teacher's voice dose not match with background content that are plays
A
Aakash Mavar
5
Hello sir
Mera Abhi graduation hu he Mene Mechanical Engineering BTech ki Hai me Data analysis me Apna career Bana skat ho Kya
Share a personalized message with your friends.