difference between select query and View In that view, we can write the query like ex : join of two tables where as in select query we can write those query. So what is the major difference between select query and view
Within the query optimizer, there is effectively no difference at all. The view is nothing more than a mask on top of a query that appears to act like a table. But it is absolutely not a table and should never be thought of as such. The exception to that is the materialized view which is actually a table to all intents and purposes.