using Views vs Table

Posted in 2004

Topics: Performance & Tuning, SQL Development & Query Writing

Wayne — 5 May 2004 16:44:31 -0700 — source: Usenet: comp.databases.informix

Hi All, Just curious, is there pro/con write SQL query using "view" instead the actual "table"? My programmer created many VIEW and he using those VIEWs in his SQL query. I wonder if using VIEW, it may cause performance to the system or overhead. Thanks for your input. --Wayne

↪ replying to Wayne

Madison Pruet — Thu, 06 May 2004 01:42:38 GMT — source: Usenet: comp.databases.informix

If the view is a simple view, then it really won't cause any performance issue. However, if the view has additional complexity that the query doesn't need, then using a view will be more expensive. Basicaly a view is an sql macro. When the query is against a view, the query plan is expanded by the view definition. M.P. "Wayne" <ngte4-gl@yahoo.com> wrote in message news:fe6569b.0405051544.14a5732a@posting.google.com... > Hi All, > > Just curious, is there pro/con write SQL query using "view" instead > the actual "table"? My programmer created many VIEW and he using those > VIEWs in his SQL query. I wonder if using VIEW, it may cause > performance to the system or overhead. Thanks for your input. > > --Wayne