SQL View vs Derived Table

Question

I always thought of representation as a stored request. Recently, I needed to use Derived Tables in a project. It made me think about ideas.

Doesn’t it look the same as in the view, except that it was saved as a logical entity, where the view is built on the fly?

Answer 1

Yes, for most purposes and purposes they can be considered as you described. They are one and the same idea.

In some DBMSs, you can do more interesting things with a view. Indexing is the first thing that comes to mind. You can also provide restrictions on access to views, as they are the proper database objects.

Take a look at Derived tables in SQL for more information.