Re: Using Views
Posted in 2000
Anne Shelp — — source: Informix-list mailing list archive (1991-1998)
This is because the underlying SQLs have to be satisfied every time the view is referenced. >>> Esther <estherNOesSPAM@ts.es.invalid> 05/23/00 10:19AM >>> Since I have created some views in my DataBase, all the SELECT statement s go more slow. The Select statements query tables that don t have views. When I drop the views, the Select statements return the data faster. ' Can anybody tell me why the views makes the database slow? Thank you. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!