10-03 view advantages and disadvantages and considerations

Advantages of using Views:

The view focuses on feature data.

Simplify the operation of data, easy to maintain.

Disadvantages of using Views:

The operation view is slower than manipulating the underlying table directly.

Modify the limit.

Considerations for Using Views:

The SELECT statement under the view definition cannot include content:

ORDER by statement, unless there is also a top clause in the Select selection list.

into keyword.

Refers to a temporary table or table variable.

10-03 view advantages and disadvantages and considerations