In response to richard terry :
> I wondered if when creating a new view from multiple tables, and then also
> joining to some fields of an existing view, if one pays much of a speed
> penalty when the data is retrieved, as opposed to just completely using all
> tables.
Depends.
The upcoming release 9.0 contains a new feature called 'join removal'.
http://akretschmer.blogspot.com/2010/02/join-removal-short-performance-test.html
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99