Re: VIEW execution time
Chad Dunham wrote:
> I am then UNION ALL the select * from each the
MySQL would solve this by using the TEMPTABLE algorithm (=compute the resultset, store in temporary table, select from the temporary table) - this would explain why it takes longer than the sum of execution times of the individual views
Subject
Written By
Posted
Re: VIEW execution time
March 29, 2006 02:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.