SQL server optimal query design (转载) - Database版

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - SQL server optimal query design (转载)

相关主题
● 问Jackrun, Beijing等大侠performance问题	● A SQL query never stop running is bothering me: help needed (转载)
● how to make query faster?	● What is optimizer statistics of a table and what is access plan of a query
● Late afternoon 腦不好使	● [转载] 求教数据库的query optimization 工作的面试
● Job openings with Teradata (zt)	● How to improve performance of Database?
● 一个SQL query的问题	● 关于DATABASE 的研究方向
● [转载] question about SQL in Access	● 谁能推荐关于 sql query optimization 方面的书？
● [转载] Can anyone interpret this simple SQL?	● 请问个join的问题
● parameterized queries with no inputs	● sqlserver Query的问题

相关话题的讨论汇总
话题: query话题: sql话题: design话题: optimal话题: server

进入Database版参与讨论

(共1页)

l******9
发帖数: 579

【以下文字转载自 Quant 讨论区】
发信人: light009 (light009), 信区: Quant
标题: SQL server optimal query design
发信站: BBS 未名空间站 (Fri Jul 4 12:54:15 2014, 美东)
I need do some SQL server query design.
For doing the same query, there may be many different kinds of query design.
But, I need to learn which kinds of query design/implementation are optimal
for performance.
Could anybody recommend some books/publications to learn how to do that ?
Any help would be appreciated.

(共1页)

进入Database版参与讨论

相关主题
● sqlserver Query的问题	● 一个SQL query的问题
● 问几个在实际工作MySQL query optimization问题	● [转载] question about SQL in Access
● oracle和XML	● [转载] Can anyone interpret this simple SQL?
● 帮帮忙	● parameterized queries with no inputs
● 问Jackrun, Beijing等大侠performance问题	● A SQL query never stop running is bothering me: help needed (转载)
● how to make query faster?	● What is optimizer statistics of a table and what is access plan of a query
● Late afternoon 腦不好使	● [转载] 求教数据库的query optimization 工作的面试
● Job openings with Teradata (zt)	● How to improve performance of Database?

相关话题的讨论汇总
话题: query话题: sql话题: design话题: optimal话题: server

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

boards

未名新帖统计// 7月16日

历史上的今天