MySQL Forums
Forum List  »  General

VIEW execution time
Posted by: Chad Dunham
Date: March 28, 2006 10:20PM

I have three views that take the following times to retrieve their record sets:

View 1 (0.14 sec with 1760 rows)
View 2 (0.05 sec with 296 rows)
View 3 (0.25 sec with 3397 rows)

I am then UNION ALL the select * from each the above views. The total time to return the UNION view is 1.6 sec. Does this seem like a reasonable time?

Sincerely

Chad

Options: ReplyQuote


Subject
Written By
Posted
VIEW execution time
March 28, 2006 10:20PM
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.