[Solved] MySQL View is faster or not for querying from DB that containd 40 million data [closed]

[ad_1]

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

[ad_2]

solved MySQL View is faster or not for querying from DB that containd 40 million data [closed]