Yes, It is possible to reduce query time using view because it have clustered index assigned and they’ll store temporary result that can speed up resulting queries.
2
solved MySQL View is faster or not for querying from DB that containd 40 million data [closed]