請教各位先進:
我們在撰寫view時以下哪種方法較好?Why?Performance好?or 便於Read?便於Maintain?
1.一個View解決:
Select ... From (Select ... From (Select ... From ...)) t1 join (Select ... From ...) t2 on ......
2.多個中間過程View,最後再一個View去串:
V1:Select ... From ...
V2:Select ... From ...
V3:Select ... From ...
V4:Select ... From ...
...
Vx:Select ... From V1 join V2 ...V3...V4...

謝謝!
arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(1) 人氣()