Re: Performance of Views

[Felix Geerinckx]

Scott Sosna wrote:

> I have a query which joins four tables. When I explain the query directly (SELECT
> a, b, c, d FROM tab1, tab2...), the time is very good. When I explain the query through the view
> (SELECT * FROM view), the time goes up to 4 seconds. The query plans on each are fairly similar,
> except that the view's plan uses DERIVED instead of the four SIMPLE's I get with the query
> directly.

Would you care to post both EXPLAIN results, together with the exact command to generate them?
(and please use \G at the end instead of ; to keep the results readable).

--
felix
Please use BBCode to format your messages in this forum.