Using Views better than a advance query

[Metalzed]

Hi.

 

Lets say that you have a very advance query you like to preform.

 

eg.

In the query there is 7 tables with Join. 5 Sub-SELECT querys

 

Would you split it up and doing views.

Lets say 3 diffrent Views and then you can use one Query with 3 joins and 1 Sub-Select

 

 

It is a lot easier to find error when you split it up.

Also to do changes.

 

But

 

Is it a lot slower?

Is there any other reason not to do it?

 

 

 

[fenway]

There are no materialized views in mysql, so it's basically the same.