Report or View ?

Posted in 2004

Dirk Moolman — Fri, 23 Apr 2004 15:45:47 +0200 — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------_=_NextPart_001_01C42939.47F5A969 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Quick question. We currently have space problems. The MIS users = (when they run large reports) create tables with subsets of data, and = then run their final queries on these subsets. =20 Due to the space issue we cannot create these subsets right now. Will = it be really bad for performance to replace these subsets with views ? =20 =20 =20 =20 =20 =20 Dirk Moolman Database and Unix Administrator MXGROUP =20 =20 "People demand freedom of speech as a compensation for the freedom of = thought which they seldom use."=20 -Kierkegaard=20 =20 ________________________________ << ella for Spam Control >> has removed 449 Spam messages and set aside = 307 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com=09 ------_=_NextPart_001_01C42939.47F5A969 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)"> <style>  </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> Quick question.      We currently have = space problems.  The MIS users (when they run large reports) create tables with subsets of data, and = then run their final queries on these subsets.   Due to the space issue we cannot create these subsets right now. =  Will it be really bad for performance to replace these subsets with views = ?             Dirk Moolman Database and Unix Administrator MXGROUP     "People demand freedom of speech as a compensation for the = freedom of thought which they seldom use." -Kierkegaard   </div> </body> </html> <hr><table border=3D"1" cellpadding=3D"8" = cellspacing=3D"0" bgcolor=3D"#FFFF99" bordercolor=3D"#999999"><tr><td = align=3D"center">&lt&lt ella for Spam Control &gt&gt = has removed 449 Spam messages and set aside = 307 Newsletters for me You can use it too - and it's = FREE!&nbsp&nbsp<a = href=3D"http://www.ellaforspam.com">www.ellaforspam.com</a></td></= tr></table>=00 ------_=_NextPart_001_01C42939.47F5A969-- sending to informix-list

Report or View ?

Related threads

Your privacy choices