Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!sdd.hp.com!hplabs!hpcc05!hpsgm2!wongj From: wongj@hpsgm2.sgp.hp.com (Jimmy Wong) Newsgroups: comp.databases Subject: Performance of views in relational database Message-ID: <1070003@hpsgm2.sgp.hp.com> Date: 4 Oct 90 10:29:27 GMT Organization: HP Singapore Lines: 12 I am designing a relational database that need to join information from quite a number of tables. Can someone tell me will there be a difference in performance if I join the information using a view as oppose to joining the information at run-time ? Thank you in advance. -- Jimmy Wong phone: +65 279-8755 Singapore Networks Operation Unix mail: wongj@hpsgm2.sgp.hp.com Hewlett-Packard 1150 Deport Road Singapore 0410