|
Posted by --CELKO-- on 03/09/06 04:53
>> I hate views. They are inefficient, they are slow, and they do not allow flexibility. <<
Actually they can be VERY efficient in most products. If the text of
the VIEW definition is copied as an "in-line macro", it works just like
a CTE or derived table. That is rather fast.
If the VIEW definition is materialized, several products will share
that materialized table in cache. Oracle has this feature, for
example.
Navigation:
[Reply to this message]
|