q: table rows are usually unique, in a standard design, but many derived views are not. Example please?
A: if you select just 1 column.
q: why views can’t be indexed like tables?
A: no physical storage of the data
q: name an obvious headache of using “distinct” in a view definition? Name a solution.
I think sybase 15 allows it.