FalseDawn - 10:45 pm on Nov 10, 2006 (gmt 0)

1) Are views the best thing since sliced bread or the offspring of satan?

Used appropriately, somewhere between the 2 :)

2) Do you use them? If so, when, where, why, and how?

Not religiously, but they have their place. You have already mentioned some benefits, which I agree with - I would add that they can also help add some transparency to complex queries, too (or should that be remove transparency from?)

(black box, implementation hiding, much like stored procedures).

[edited by: FalseDawn at 10:48 pm (utc) on Nov. 10, 2006]