[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