There is no big performance difference between the two methods.

来源: 2008-10-10 10:53:13 [旧帖] [给我悄悄话] 本文已被阅读:

I would put my concentration on how to create your tables based on your display query.
For instance
if your display query is like following

select table1.col1 || table2.col2
from table1,table2
where table1.col1='xxx' and table2.col2='yyy'

you should create indexes for table1.col1 and table2.col2 when you create tables.
There is a huge difference in performance if you don't do that