What database system do you use?

Also, you need to give a real query since in some systems, you can explicitly specify what algorithms is used to create the view. The performance difference can be significant.

所有跟帖： 

• hi，大侠。一定要告诉我们你的答案。本想把你喊出来的：） -戏雨飞鹰- ♀ (0 bytes) () 10/10/2008 postreply 21:59:24

• I am far from a DX, Just a database person. -ffppyy- ♂ (1386 bytes) () 10/11/2008 postreply 11:31:11

• 俺顶你，有事没事就弄“景”（VIEW）的人，我总想再背后跩他一脚！ -以后再说- ♂ (0 bytes) () 10/11/2008 postreply 14:14:23

• who are you? you are new here? :) -戏雨飞鹰- ♀ (0 bytes) () 10/11/2008 postreply 14:30:48

• 我是who?， 以后再说！ -以后再说- ♂ (58 bytes) () 10/11/2008 postreply 15:24:31

• :) no need 以后再说. -戏雨飞鹰- ♀ (0 bytes) () 10/11/2008 postreply 15:27:23

• Many thanks for the cogent answer :). I like it. -戏雨飞鹰- ♀ (265 bytes) () 10/11/2008 postreply 14:29:18

• 俺不懂了 -以后再说- ♂ (76 bytes) () 10/10/2008 postreply 23:05:01

• 回复：俺不懂了 -ffppyy- ♂ (80 bytes) () 10/11/2008 postreply 11:08:18