T*e
3 楼
about SQL optimization, I guess
there are some research results
well, some are common sense
for example, if you have a big table to join
do a projection 1st, then join
...
【在 a*****a 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: dont understand what you are asking about.
: MS SQL Server will cache your sql script so next time it'll
: not be recompiled. Is this what you mean? Or another tip is
: that use Stored Proc.
there are some research results
well, some are common sense
for example, if you have a big table to join
do a projection 1st, then join
...
【在 a*****a 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: dont understand what you are asking about.
: MS SQL Server will cache your sql script so next time it'll
: not be recompiled. Is this what you mean? Or another tip is
: that use Stored Proc.
T*e
5 楼
when I took DB course I got a paper on this
look if I can find it or not
or you can ask any prof. in DB field
or guys who are doing research on DB
it's basic knowledge of 'advanced DB'
hoho
【在 a*i 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 谢谢两位热心的大侠,
: 噢,我的问题是与具体的数据库无关的:
: 主要是在作B/S模式访问数据库时,客户端的SQL语句的优化问题
: 。
: 以前在计算机世界上见到过一篇这个主题的短文,很有益处,不
: 知
: 网上是否有其他帮助?
look if I can find it or not
or you can ask any prof. in DB field
or guys who are doing research on DB
it's basic knowledge of 'advanced DB'
hoho
【在 a*i 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 谢谢两位热心的大侠,
: 噢,我的问题是与具体的数据库无关的:
: 主要是在作B/S模式访问数据库时,客户端的SQL语句的优化问题
: 。
: 以前在计算机世界上见到过一篇这个主题的短文,很有益处,不
: 知
: 网上是否有其他帮助?
相关阅读
Has anybody used Sybase? Urgent help!switchboard怎么建立啊?请问哪里有sql语句追踪工具急!怎么做模糊查询?[转载] 还有个技术问题,请大拿们指导Sybase Server setting questionsquestion on nested queryRe: 诚心请教 (SQL) => Try This Please:OK, found the right tool.请问哪里有sql语句追踪工具如何migrate Oracle DB[求助] 数据库的工作--现场面试谁有常见Database interview questions?What is a relational table?求教:数据操作query操作How To Retrieve This Record? 谢谢有没有人用postgres?有个drop table的问题Microsoft 的MCDBA certificate 对找工作有多大帮助?免费下载的Oracle跟买的没有区别吗?[转载] Recommend a platform and design