[wplug-web] schema for mailing lists

Mark Dalrymple wplug at badgertronics.com
Fri Feb 21 16:17:50 EST 2003


> I've not dealt with views much. Are they cheaper than an equivelent join?

They're usually equivalent to pasting in the view definition into
the query.  Deep levels of  views can sometimes make the optimizer
miss some options.  In terms of person understanding , views can be
helpful for hiding complex queries involving joins across lots of tables.

Wheee,
++Mark Dalrymple, markd at badgertronics.com.  http://badgertronics.com
  "Q: I need a random number generator.
   A: Count errors in Herbert Schildt's C books.  No one has detected any
      consistent pattern." -- Peter Seebach, from The *other* C FAQ




More information about the Wplug-web mailing list